출처 : <a href="http://blog.naver.com/PostView.nhn?blogId=sunye79&amp;logNo=60057090475&amp;redirect=Dlog&amp;widgetTypeCall=true" target="_blank">http://blog.naver.com/PostView.nhn?blogId=sunye79&amp;logNo=60057090475&amp;redirect=Dlog&amp;widgetTypeCall=true</a> 
 
 

1. 순번출력<o:p></o:p>
&nbsp;<o:p></o:p>
SELECT ROW_NUMBER() OVER(ORDER BY 컬럼명1) AS 순번<o:p></o:p>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ,컬럼명2<o:p></o:p>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ,컬럼명3<o:p></o:p>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; FROM 테이블명<o:p></o:p>
&nbsp;<o:p></o:p>
2. 그룹별 순위출력<o:p></o:p>
&nbsp;<o:p></o:p>
SELECT ROW_NUMBER() OVER(PARTITION BY 컬럼1 ORDER BY COLUMN2) AS 순번<o:p></o:p>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ,컬럼명1<o:p></o:p>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ,컬럼명2<o:p></o:p>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; FROM 테이블명<o:p></o:p>

MSSQL 순번 출력, 그룹순번출력 row , row_number