select * from (select * from NA_USEPERCENTPERDAY t order by t.id) where rownum<8;
Oracle根据时间排序查询最后7条数据
原文:http://www.cnblogs.com/xinxin1994/p/6225414.html