SELECT COL_1, COL_2, COL_3, COL_4, COUNT(*) FROM MyTable GROUP BY COL_1, COL_2, COL_3, COL_4
如果您要清除没有重复的行,请执行以下操作:
SELECT COL_1, COL_2, COL_3, COL_4, COUNT(*)
FROM MyTable
GROUP BY COL_1, COL_2, COL_3, COL_4
HAVING COUNT(*) > 1
如何在几列中查找重复计数?
SELECT COL_1, COL_2, COL_3, COL_4, COUNT(*) FROM MyTable GROUP BY COL_1, COL_2, COL_3, COL_4
如果您要清除没有重复的行,请执行以下操作:
SELECT COL_1, COL_2, COL_3, COL_4, COUNT(*)
FROM MyTable
GROUP BY COL_1, COL_2, COL_3, COL_4
HAVING COUNT(*) > 1