출처 : <a href="http://www.sqler.com/index.php?_filter=search&amp;mid=bSQLQA&amp;search_target=title&amp;search_keyword=%EC%B5%9C%EA%B7%BC&amp;document_srl=498496" target="_blank">http://www.sqler.com/index.php?_filter=search&amp;mid=bSQLQA&amp;search_target=title&amp;search_keyword=%EC%B5%9C%EA%B7%BC&amp;document_srl=498496</a>
 

SELECT *<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p>
FROM<o:p></o:p>
(<o:p></o:p>
&nbsp;&nbsp;&nbsp; SELECT *, ROW_NUMBER() OVER (PARTITION BY <span style="COLOR: red; mso-bidi-font-family: 'Courier New'; mso-no-proof: yes; mso-bidi-font-size: 10.0pt; mso-font-kerning: 0pt; mso-ascii-font-family: 'Courier New'; mso-hansi-font-family: 'Courier New'">칼럼 ORDER BY <span style="COLOR: red; mso-bidi-font-family: 'Courier New'; mso-no-proof: yes; mso-bidi-font-size: 10.0pt; mso-font-kerning: 0pt; mso-ascii-font-family: 'Courier New'; mso-hansi-font-family: 'Courier New'">날짜 DESC) AS RN<o:p></o:p>
&nbsp;&nbsp;&nbsp;&nbsp; FROM <span style="COLOR: red; mso-bidi-font-family: 'Courier New'; mso-no-proof: yes; mso-bidi-font-size: 10.0pt; mso-font-kerning: 0pt; mso-ascii-font-family: 'Courier New'; mso-hansi-font-family: 'Courier New'">테이블명<o:p></o:p>
) AS sub1<o:p></o:p>
WHERE RN = 1<o:p></o:p>
 
&nbsp;

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