sq2000 中无法使用row_number()
使用
select ( select count(*)
from xzt_da_Topic p1
where p1.id <= p2.id) as ABC,
* from xzt_da_Topic p2
order by ABC 代替
sq2000 中无法使用row_number()
使用
select ( select count(*)
from xzt_da_Topic p1
where p1.id <= p2.id) as ABC,
* from xzt_da_Topic p2
order by ABC 代替