DELETE
t
FROM
(
SELECT
*,ROW_NUMBER()OVER(PARTITION
BY
test1,test2,test3,test4
ORDER
BY
RAND())
AS
RN
FROM
TableName)
AS
t
WHERE
RN>1
转载于:https://www.cnblogs.com/ainidewen/p/9196929.html
DELETE
t
FROM
(
SELECT
*,ROW_NUMBER()OVER(PARTITION
BY
test1,test2,test3,test4
ORDER
BY
RAND())
AS
RN
FROM
TableName)
AS
t
WHERE
RN>1
转载于:https://www.cnblogs.com/ainidewen/p/9196929.html