复合语句的问题?select * from user where id not in (select top 15 id from user order by id) order by id "
xieqi 2003-10-17 12:54:10 select * from user where id not in (select top 15 id from user order by id) order by id
这句sql在mssql里可以用,但在oracle里不能。
我改成select * from user where id not in (select id from user where rownum <=15 order by id) order by id
还是不行。
=================================================
select * from ctxsys.attribute where id not in (select id from ctxsys.attribute where rownum <= 3 order by id)order by id
*
ERROR 位于第 1 行:
ORA-00907: 缺少右括号
select * from ctxsys.attribute where id not in (select id from ctxsys.attribute where rownum <= 3 )order by id
这句可以,为什么order by id 加在rownum <= 3后面就不行呢??