select * from (select rownum as r,t.* from
(select emp.* from emp order by hiredate desc) t where rownum<=10)
where r>5;
谁能不这句话转化为sql server中可以运行的sql语句
(select emp.* from emp order by hiredate desc) t where rownum<=10)
where r>5;
谁能不这句话转化为sql server中可以运行的sql语句
SELECT *
FROM ( SELECT rownum AS r ,
t.*
FROM ( SELECT emp.*,ROW_NUMBER()OVER(ORDER BY GETDATE()) AS rownum
FROM emp
ORDER BY hiredate DESC
) t
WHERE rownum <= 10
)
WHERE r > 5;
select * FROM emp order by hiredate desc OFFSET 5 ROWS FETCH NEXT 5 ROWS ONLY;
----------实现rownum
SELECT *, ROW_NUMBER() OVER(ORDER BY ID ASC) ------实现rownumber---------相同值字段分组显示rownum
ROW_NUMBER() OVER(partition by ttid ORDER BY ttid ASC) as rownum