62,046
社区成员
发帖
与我相关
我的任务
分享请发表友善的回复…
发表回复
程序漫步 2009-05-24
- 打赏
- 举报
with temp1 as(
select ROW_NUMBER() over(order by ccode) 'rowNum',*
from tabcompany
)
select * from temp1
where rowNum between 1 and 4
创建行号~~
select ROW_NUMBER() over(order by ccode) 'rowNum',*
from tabcompany
)
select * from temp1
where rowNum between 1 and 4
创建行号~~
Wayne 2009-05-24
- 打赏
- 举报
利用ROW_NUMBER()创建分页语句，传入起始行就行了，一下例子是取第1条到第4条记录。
with temp1 as(
select ROW_NUMBER() over(order by ccode) 'rowNum',*
from tabcompany
)
select * from temp1
where rowNum between 1 and 4
