동일 칼럼 중 최신 데이터 1개 ROW만 출력하기 동일 bbs_code 중 최신 데이터 1개 ROW만 출력하기
-- MS-SQL (거지 같은 DB)
SELECT R.* FROM ( SELECT P.* FROM ( SELECT * FROM bbs_board AS C WHERE EXISTS ( SELECT bbs_code , MAX(bbs_edate) AS bbs_edate FROM bbs_board GROUP BY bbs_code ) ) AS P ORDER BY bbs_edate DESC ) AS R GROUP BY bbs_code ;