select * from (select rownum no,id,name from student where rownum<=3 ) where no >=2;
为什么别名的那个条件不能和rownum用and连接放在内层,把外层去掉啊
select rownum no,id,name from student where rownum<=3 and no >=2;
...全文
1778打赏收藏
oracle rownum 查询条件分开
select * from (select rownum no,id,name from student where rownum=2; 为什么别名的那个条件不能和rownum用and连接放在内层,把外层去掉啊 select rownum no,id,name from student where rownum=2;