SQL2005 高效率分页sql语言

发布时间：2023-08-08 14:24:09 所属栏目：MsSql教程来源：

导读：SQL2005 高效分页sql语句

1、<div class="codetitle"><a style="CURSOR: pointer" data="34283" class="copybut" id="copybut34283" onclick="doCopy('code34283')"> 代码如下:

<d

SQL2005 高效分页sql语句

1、<div class="codetitle"><a style="CURSOR: pointer" data="34283" class="copybut" id="copybut34283" onclick="doCopy('code34283')"> 代码如下:

<div class="codebody" id="code34283">

select top 10 from

( select top (@Page 10) ROW_NUMBER() OVER (order by id) as RowNum,id,username

from Guest where username = 'user'

) as T

where RowNum > ((@Page - 1) 10)

2、

<div class="codetitle"><a style="CURSOR: pointer" data="25997" class="copybut" id="copybut25997" onclick="doCopy('code25997')"> 代码如下:

<div class="codebody" id="code25997">

select from

( select ROW_NUMBER() OVER(order by id) as RowNum,username

from Guest where username = 'user'

) as T

where RowNum between 31 and 60

3、

<div class="codetitle"><a style="CURSOR: pointer" data="3970" class="copybut" id="copybut3970" onclick="doCopy('code3970')"> 代码如下:

<div class="codebody" id="code3970">

with T as

(select ROW_NUMBER() OVER(order by id) as RowNum,username

from Guest where username = 'user'

)

select * from T

where RowNum between 31 and 60

（编辑：聊城站长网）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!