前十条
select * from (
select * from table_name order by column_name
)
where rownum <= 10后十条
select * from (
select * from table_name order by column_name desc
)
where rownum <= 10
select * from (
select * from table_name order by column_name
)
where rownum <= 10后十条
select * from (
select * from table_name order by column_name desc
)
where rownum <= 10
select * from(select rownum id,tbname.* from tbname) t where t.id>=(select count(1)-10 from tbname);
select * from (select a.*,row_number() over(order by rownum desc) rm from table_name a) where rm<11;
select * from(select rownum id,tbname.* from tbname) t where t.id>=10 and t.id<=20;