Column 카테고리 별 가장 최신 데이터 가져오기

출처 : http://www.sqler.com/index.php?_filter=search&mid=bSQLQA&search_target=title&search_keyword=%EC%B5%9C%EA%B7%BC&document_srl=498496

SELECT *

FROM

(

    SELECT *, ROW_NUMBER() OVER (PARTITION BY 칼럼 ORDER BY 날짜 DESC) AS RN

     FROM 테이블명

) AS sub1

WHERE RN = 1