摘要： slqserver：select * from( select a.column1,a.column2,a.column3 , row_number() over(order by a.column1) as rn from table_a) as tbwhere tb.rn between 1 and 500db2:select * from( select a.column1,a.column2,a.column3 , rownumber() over(order by a.column1) as rn from table_a) as tbwhere tb.rn between ... 阅读全文