oracle 获取某字段有最大值的那一行的整行记录
select * from (
select r.*,row_number() over (order by r.age desc) rnum
from user r
where r.sex = '男'
) temp where rnum = 1;
版权声明：本文为qq_35606010原创文章，遵循CC 4.0 BY-SA版权协议，转载请附上原文出处链接和本声明。
select * from (
select r.*,row_number() over (order by r.age desc) rnum
from user r
where r.sex = '男'
) temp where rnum = 1;