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