oralce top x 写法 

select * from (select * from aaa.computers order by comNo) where 

rownum<=x;(x代表要取得前多少行)

posted @ 2015-06-14 11:19  172257861  阅读(89)  评论(0)  编辑  收藏  举报