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