根据A字段去重并取最新日期的数据(B=date)
Select * from (Select *,row_number() over(partition by A order by B desc) num from table ) where num =1
根据A字段去重并取最新日期的数据(B=date)
Select * from (Select *,row_number() over(partition by A order by B desc) num from table ) where num =1