分组排序代码
select * from (
select col1 ,col2 ,col3 (按这个分组),col4(按这个排序),
row_number() over(partition by col3 order by col4 desc) as "sort"
from database ) c where c."sort" = 1
分组排序代码
select * from (
select col1 ,col2 ,col3 (按这个分组),col4(按这个排序),
row_number() over(partition by col3 order by col4 desc) as "sort"
from database ) c where c."sort" = 1