select * from
(select *,row_number() over (order by createdtime) as rownum from user) as tbl
where rownum between 1 and 5
order by createdtime
其中rownum between 处是开始记录与结束记录的值
关键就是row_number()函数
select * from
(select *,row_number() over (order by createdtime) as rownum from user) as tbl
where rownum between 1 and 5
order by createdtime
其中rownum between 处是开始记录与结束记录的值
关键就是row_number()函数