日期:2014-05-18  浏览次数:20558 次

这句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)t
where
 1=1 and rownum=3