select distinct MemberId, Mobile,IdCard,row_number() over(partition by MemberId order by OperateTime desc) as co1 from 表1 where MemberId='123456' group by MemberId,Mobile,IdCard,OperateTime order by co1
sqlserver获取分组中的行号
最新推荐文章于 2024-05-21 14:20:20 发布