Question

sql语句查询结果的排列序号？怎么获取到序号

Answer 1

select * from (select row_number() over (order by 排序字段) row,* from 数据表) newtable

Answer 2

没有这样的SQL函数或语句，只能用别的方法实现，如结合别的程序或游标等

Answer 3

oracle rownum

select rownum, t.* from tables t
order by t.id