oracle数据库-查询一张表中某个字段按照降序排列的前十条数据
select * from (select * from ldcode where 1=1 order by code desc) where rownum<11--这样写是对的
select * from ldcode where 1=1 order by code desc rownum<11--这样写报错了
select * from (select * from ldcode where 1=1 order by code desc) where rownum<11--这样写是对的
select * from ldcode where 1=1 order by code desc rownum<11--这样写报错了