如果是前后的问题,可以没有主键,但是要有一个唯一字段能表示先后顺序才行
否则讨论先后没有意义
select * from (select * from tablename order by field_name desc) where rownum <=10
否则讨论先后没有意义
select * from (select * from tablename order by field_name desc) where rownum <=10
minus
select * from aaa a where rownum<(select count(1)-9 as num from aaa b)
select * from aaaselect * from aaa a
minus
select * from aaa a where rownum<(select count(1)-9 as num from aaa
select * from aaaselect * from aaa a
minus
select * from aaa a where rownum<(select count(1)-9 as num from aaa b)