这句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
发布时间: 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无效
[解决办法]
select * from(select *,(Row_Number() over(order by id)) as rownum from R_ExamOptions)twhere 1=1 and rownum=3