当前位置:数据库 > > 正文

sqlserver分页查询sql语句(sql server实现分页的方法实例分析)

时间:2022-01-24 00:47:28类别:数据库

sqlserver分页查询sql语句

sql server实现分页的方法实例分析

本文实例讲述了sql server实现分页的方法。分享给大家供大家参考,具体如下:

  • declare @index int,@num int
    set @index = 1--当前页
    set @num = 2--单页包含的行数
    --分页1
    select top (@num) *
    from ppohd
    where doccode not in
    (
      select top (@num * (@index -1)) doccode
      from ppohd
      order by doccode
    )
    order by doccode
    --分页2
    select top (@num) *
    from ppohd
    where doccode >=
    (
      select max(doccode)
      from
      (
        select top (@num * (@index - 1) + 1) doccode
        from ppohd
        order by doccode
      ) as tb
    )
    --分页3
    select top (@num) *
    from
    (
      select ppohd.doccode as 'mydoccode',row_number() over (order by doccode) as sno,*
      from ppohd
    ) as tb
    where tb.sno >= @num * (@index - 1) + 1
    --分页4
    select *
    from
    (
      select ppohd.doccode as 'mydoccode', row_number() over(order by doccode) as sno,*
      from ppohd
    ) as tb
    where tb.sno between (@num * (@index - 1) + 1) and (@num * @index)
    
    
    
  • 更多关于SQL Server相关内容感兴趣的读者可查看本站专题:《SQL Server分页技术总结》、《SQL Server查询操作技巧大全》、《SQL Server存储过程技巧大全》、《SQL Server索引操作技巧大全》、《SQL Server常用函数汇总》及《SQL Server日期与时间操作技巧总结》

    希望本文所述对大家SQL Server数据库程序设计有所帮助。

    标签:
    上一篇下一篇

    猜您喜欢

    热门推荐