sql server2005和oracle分页查询语句

最新推荐文章于 2024-06-27 10:58:53 发布

may_walkaway

最新推荐文章于 2024-06-27 10:58:53 发布

阅读量335

点赞数

分类专栏： java学习文章标签： oracle server sql 分页

本文链接：https://blog.csdn.net/sinat_27535209/article/details/48109787

版权

java学习专栏收录该内容

30 篇文章 1 订阅

订阅专栏

oracle:
select t.* from (select rownum rn,u.* from car_user u where 1=1 and loginname like '%a%') t
where t.rn<=6 and t.rn>=4


sql  server2005:
①
DECLARE @Start INT
DECLARE @End INT
SELECT @Start = 1,@End = 3

SELECT *
FROM (SELECT *,
ROW_NUMBER() OVER (ORDER BY price) AS RowNumber
FROM product) EmployeePage
WHERE RowNumber >= @Start AND RowNumber <= @End
ORDER BY price

②
select *from (select row_number()over(order by tempcolumn)temprownumber,* from (select top 3 tempcolumn=0,* from product)t)tt where temprownumber>=1