语法:ROW_NUMBER() OVER(ORDER BY COLUMN)
含义:从1开始,对每一条数据排序后返回一个数字:
select adddate,ROW_NUMBER() OVER(ORDER BY adddate desc) as counts from userinfo
下面使用ROW_NUMBER() 查询0到10条数据:
select *
from(select adddate,ROW_NUMBER() OVER(ORDER BY adddate desc) as counts from userinfo)
where counts between 0 and 10