Notice
Recent Posts
Recent Comments
목록순번 (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
반응형