Oracle 取查询结果排序后的第一条记录

select * from (select t.*, row_number() over(order by id) rn from test_order t) t where rn = 1;