![](https://img-blog.csdnimg.cn/20201014180756913.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
SQL
yriio
暂无 @_@
展开
-
SQL语句
** ** order by ** desc limit 0,5排序之后取前5行原创 2008-05-06 18:40:00 · 416 阅读 · 0 评论 -
oracle sql分页的问题
<br />用rownum和order by的时候, 是rounum先生成然后才去更具order by的条件进行排序,所以如果order by以后想要分页的话,需要嵌套三层的sql才行:<br /> <br /> <br />select * from (select rownum ,a.* from (select * from tablename order by something) a) where rownum <10; <br /> <br /> <br />原创 2011-02-21 15:40:00 · 398 阅读 · 0 评论