1 頁 (共 1 頁)

SQL 2000 row_number

發表於 : 2018-05-29 22:13:39
yehlu
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