What is a SQL query to find duplicates in a table?

• A. SELECT column_list, COUNT(*) FROM table GROUP BY column_list HAVING COUNT(*) > 1;
• B. SELECT DISTINCT column_list FROM table;
• C. DELETE FROM table WHERE id IN (SELECT id FROM table GROUP BY column_list HAVING COUNT(*) > 1);
• D. SELECT * FROM table WHERE COUNT(*) > 1;

Answer: (A)