22,296
社区成员
发帖
与我相关
我的任务
分享sql server里面有没有像oracle中rownum一样的东西,怎样得到
sql server里面有没有像oracle中rownum一样的东西,怎样得到
...全文
请发表友善的回复…
发表回复
michoal 2003-06-18
- 打赏
- 举报
还有好的方法没有
pengdali 2003-05-11
- 打赏
- 举报
select (select count(*) from yourTable where key<=t.key) as rownum,*
from yourTable as t
from yourTable as t
w_rose 2003-05-11
- 打赏
- 举报
谁能说清楚 oracle 中的 rownum 是怎么设计的(oracle系统设怎么设计的)？
光知道rownum概念有什么用？
光知道rownum概念有什么用？
w_rose 2003-05-11
- 打赏
- 举报
呵呵
select (select count(*) from yourTable where key<t.key) as rownum,*
from yourTable as t
select (select count(*) from yourTable where key<t.key) as rownum,*
from yourTable as t
pengdali 2003-05-11
- 打赏
- 举报
没有！
只有：
select IDENTITY(int, 1,1) AS ID_Num,* into #temp from 表
select * from #temp where ID_Num between 10 and 20
drop table #temp
只有：
select IDENTITY(int, 1,1) AS ID_Num,* into #temp from 表
select * from #temp where ID_Num between 10 and 20
drop table #temp
