select * from |
| ( select a.*,rownum row_num from |
| ( select * from mytable t order by t.id desc ) a |
| ) b |
| where b.row_num between 1 and 10 |
select * from |
| ( select a.*,rownum row_num from |
| ( select * from mytable t order by t.id desc ) a |
| ) b |
| where b.row_num between 1 and 10 |
转载于:https://www.cnblogs.com/pinbo/archive/2010/09/15/1827226.html