原数据
按照billdate去重,取billnumberid最大的一条
select BillDate,max(billNumberId) as billnumberid from OrderIndex group by BillDate
按照billdate去重,distinct只能去重一条
select distinct billdate from OrderIndex
按照billdate去重,取billnumberid最大的一条
SELECT * FROM (
select *,ROW_NUMBER() over(partition by billdate order by billnumberid desc) AS rn from OrderIndex ) AS u WHERE u.rn=1