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
涉及到数据量较大时,采用分页方式显示数据最佳选择