oralce top x 写法

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

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

转载于:https://www.cnblogs.com/kool/p/6695650.html