08 2021 档案

sqlserver去重只查一条数据
摘要：SELECT ModifiedBy ,IDCardNo FROM ( SELECT ROW_NUMBER() over (PARTITION BY IDCardNo ORDER BY dt DESC) AS num , ModifiedBy,IDCardNo FROM test WHERE Item 阅读全文
posted @ 2021-08-26 16:54 金虹巴巴 阅读(390) 评论(0) 推荐(0) 编辑

点击右上角即可分享
微信分享提示