oracle 获取某字段有最大值的那一行的整行记录

oracle 获取某字段有最大值的那一行的整行记录

select * from ( 
	select r.*,row_number() over (order by r.age desc) rnum 
	from user r 
	where r.sex = '男'
) temp where rnum = 1;