1、sqlserver只有三个字段,name,num,speech,如何根据name字段去重
;WITH CTE AS (
SELECT name, num, speech,
ROW_NUMBER() OVER (PARTITION BY name ORDER BY (SELECT NULL)) AS rn
FROM your_table_name
)
DELETE FROM CTE
WHERE rn > 1;
2、sqlserver只有三个字段,name,num,speech,如何根据name,num字段去重
;WITH CTE AS (
SELECT name, num, speech,
ROW_NUMBER() OVER (PARTITION BY name, num ORDER BY (SELECT NULL)) AS rn
FROM your_table_name
)
DELETE FROM CTE
WHERE rn > 1;