Question

oracle 表名无效

运行select * from (select * from where course order by cid desc) where rowunm<4; 提示问题无效
但是select * from course where rownum<4 order by cid desc;却可以执行

Answer 1

select * from (select * from where course order by cid desc)
t
where rowunm<4

Answer 2

括号内的子查询没有表，你怎么找？？？

Answer 3

select * from (select * from course order by cid desc) where rowunm<4;

Answer 4

二楼答的对，子查询没有表

Answer 5

select * from (select * from ！表名！ where course order by cid desc) where rowunm<4;
没表肿么找？