sql 实现分页
时间：2010-09-15 来源：anny0320
| 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 |
相关阅读 更多 +
排行榜 更多 +
时间：2010-09-15 来源：anny0320
| 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 |
