22,209
社区成员
发帖
与我相关
我的任务
分享Oracle 语句 转换 SQLServer
Oracle
select * from (select T.*,rownum r from nncredit_article_class T) a where r >'3' and r <=9
SQlServer 怎么写 rownum
select * from (select T.*,rownum r from nncredit_article_class T) a where r >'3' and r <=9
SQlServer 怎么写 rownum
...全文
请发表友善的回复…
发表回复
还在加载中灬 2015-03-24
- 打赏
- 举报
select * from (select T.*,ROW_NUMBER()OVER(ORDER BY GETDATE()) r from nncredit_article_class T) a where r >'3' and r <=9
