select * from (select * from NA_USEPERCENTPERDAY t order by t.id) where rownum<8; 转载于:https://www.cnblogs.com/xinxin1994/p/6225414.html