Oracle根据时间排序查询最后7条数据 select * from (select * from NA_USEPERCENTPERDAY t order by t.id) where rownum<8;