sql分组排序，查询每组第一个数据

• List item
  sql分组排序，查询每组第一个数据

select *
from (select row_number() over(partition by province_code,city_code,bank_code order by branch_code desc) rn,
bank_info.*
from bank_info)
where rn = 1  ;