数据库查询表的行标方法

slqserver：

select * from

(

　　select a.column1,a.column2,a.column3 , row_number() over(order by a.column1) as rn

 　　from table_a

) as tb

where tb.rn between 1 and 500

 

db2:

select * from

(

　　select a.column1,a.column2,a.column3 , rownumber() over(order by a.column1) as rn

　　from table_a

) as tb

where tb.rn between 1 and 500

涉及到数据量较大时，采用分页方式显示数据最佳选择