根据字段1排rownum ,根据字段2排大小
select *
from
(select
*,
row_number()
over (
partition by 字段1
order by 字段2 desc ) as rownum
from 表) info
where info.rownum = 1
根据字段1排rownum ,根据字段2排大小
select *
from
(select
*,
row_number()
over (
partition by 字段1
order by 字段2 desc ) as rownum
from 表) info
where info.rownum = 1