SQL Row_Number()函数备忘
SQL Row_Number()函数备忘
with Employee_Temp
as
(select s.*, ROW_NUMBER() OVER(ORDER BY s.order ) AS rownum
from Employee s)
select * from Employee_Temp where rownum between 10 and 20
with Employee_Temp
as
(select s.*, ROW_NUMBER() OVER(ORDER BY s.order ) AS rownum
from Employee s)
select * from Employee_Temp where rownum between 10 and 20