SQL 2000 row_number
發表於 : 2018-05-29 22:13:39
https://dotblogs.com.tw/bluebeta/2010/09/15/17744
代碼: 選擇全部
select ( select count(*)
from MAN p1
where p1.A01 <= p2.A01) as rowNumber,
* from MAN p2
order by rowNumber