sqlsever 删除重复数据保留一条

DELETE FROM uf_bgss

 
WHERE ID NOT IN (
    SELECT MAX(ID)
    FROM uf_bgss
    GROUP BY bgrq, gh, nbddh, lcbh
);

--