목록Database/SQL Server (3)
Web Dev Log
숫자앞에 0 추가
SELECTRIGHT('000' + CONVERT( VARCHAR, ROW_NO), 3) AS ROW_NO,USER_ID, USER_NAMEFROM USERS ROW_NO 의 숫자를 3자리에 맞춰 앞에 0을 채워준다
Database/SQL Server
2017. 12. 18. 22:40
ROW_NUMBER() 순번 매기기
SQL Server 순번 매기기 1. 사용법ROW_NUMBER() OVER(PARTITION BY b.machinecd, b.adate ORDER BY b.machinecd,sum(b.losstime) DESC) 2. 순번만 매길 경우SELECTROW_NUMBER() OVER(ORDER BY IDX ASC) AS ROW_NOFROM TABLEORDER BY IDX ASC 3. 역순번 매길 경우SELECTROW_NUMBER() OVER(ORDER BY IDX DESC) AS ROW_NOFROM TABLEORDER BY IDX ASC 4. 그룹화 순번SELECT ROW_NUMBER() OVER(PARTITION BY codekind ORDER BY codenm DESC) as GroupSeq, codekin..
Database/SQL Server
2017. 12. 17. 15:16
