row_number() [ms sql2005 부터 가능. 오라클은 8i 부터 가능]
create table tmptest ( a int, b int, c int, d int ) begin insert into tmptest values(1, 0, 0, 0); insert into tmptest values(0, 7, 0, 0); insert into tmptest values(0, 12, 0, 0); insert into tmptest values(0, 30, 0, 0); insert into tmptest values(0, 0, 9, 0); insert into tmptest values(0, 0, 10, 0); insert into tmptest values(0, 0, 12, 0); insert into tmptest values(0, 0, 21, 0); insert into tmp..
2007. 6. 28.