Question

如何能实现将oracle的查询结果排序后，只返回第一条记录

Answer 1

排序后用SQL语句中的LIMIT 1子句

Answer 2

select a.*
from (
select *
from B
order by B.id
) a
where a.rownum = 1;