读书人

这句sql语句如何错了答案

发布时间: 2012-09-08 10:48:07 作者: rapoo

这句sql语句怎么错了,在线等答案
select *,(Row_Number() over(order by id)) as rownum from R_ExamOptions where 1=1 and rownum=3

报错:rownum无效

[解决办法]

SQL code
select * from(select *,(Row_Number() over(order by id)) as rownum from R_ExamOptions)twhere 1=1 and rownum=3 

读书人网 >SQL Server

热点推荐