목록MSSQL 2000 (1)

분노의 챔질

반응형
MS SQL 2000 에서의 ROW_NUMBER()

select name, title, regdate, identity(int, 1, 1) seq into #PLAN_TEMP from TABLE order by regdate select D.seq, C.name, C.title, C.regdate from TABLE as C Inner Join #PLAN_TEMP as D on C.name = D.name drop table #PLAN_TEMP
Programming/SQL 2011. 3. 2. 18:51
반응형
이전 Prev 1 Next 다음