14,959
edits
Data cleaning: Difference between revisions
Jump to navigation
Jump to search
m
→Find duplicate data
| Line 348: | Line 348: | ||
-- Find duplicated data | -- Find duplicated data | ||
SELECT `content`, COUNT(*) count FROM `table_name` GROUP BY `content` HAVING count > 1; | SELECT `content`, COUNT(*) count | ||
FROM `table_name` | |||
GROUP BY `content` | |||
HAVING count > 1; | |||
SELECT tmp.* FROM | SELECT tmp.* FROM | ||