oracle 获取某字段有最大值的那一行的整行记录 select * from ( select r.*,row_number() over (order by r.age desc) rnum from user r where r.sex = '男' ) temp where rnum = 1;