SQL删除重复数据的问题

Question

数据sqlselect

Answer 1

DELETE  a
FROM    [wyz].[dbo].[ghsj] a
WHERE   EXISTS ( SELECT 1
                 FROM   ( SELECT    [付款账号] ,
                                    [收款账号] ,
                                    [交易金额] ,
                                    [交易日期]
                          FROM      [wyz].[dbo].[ghsj]
                          GROUP BY  [付款账号] ,
                                    [收款账号] ,
                                    [交易金额] ,
                                    [交易日期]
                          HAVING    COUNT(*) > 1
                        ) b
                 WHERE  a.[付款账号] = b.[付款账号]
                        AND a.[收款账号] = b.[收款账号]
                        AND a.[交易金额] = b.[交易金额]
                        AND a.[交易日期] = b.[交易日期] )
        AND [bh] NOT IN ( SELECT    MIN([bh])
                          FROM      [wyz].[dbo].[ghsj]
                          GROUP BY  [付款账号] ,
                                    [收款账号] ,
                                    [交易金额] ,
                                    [交易日期]
                          HAVING    COUNT(*) > 1 )