从表的第几条取到第几条记录
从第行到第几行下面是从数据库newCustomer表里提取第二十行到四十行的数据select * from (select (row_number() over(order by paybefore desc)) as rownumber ,* from newCustomer) as ncwhere nc.RowNumber > 20 AND nc.RowNumber<40从第行到第几行下面是从数据库newCustomer表里提取第二十行到四十行的数据select * from (select (row_number() over(order by paybefore desc)) as rownumber ,* from newCustomer) as ncwhere nc.RowNumber > 20 AND nc.RowNumber<40
