ROW_NUMBER() 순번 매기기

SQL Server 순번 매기기

1. 사용법

ROW_NUMBER() OVER(PARTITION BY b.machinecd, b.adate ORDER BY b.machinecd,sum(b.losstime) DESC)

2. 순번만 매길 경우

SELECT

ROW_NUMBER() OVER(ORDER BY IDX ASC) AS ROW_NO

FROM TABLE

ORDER BY IDX ASC

3. 역순번 매길 경우

SELECT

ROW_NUMBER() OVER(ORDER BY IDX DESC) AS ROW_NO

FROM TABLE

ORDER BY IDX ASC

4. 그룹화 순번

SELECT ROW_NUMBER() OVER(PARTITION BY codekind ORDER BY codenm DESC) as GroupSeq,

      codekind,

codenm 

FROM bicod01t