The question is to return the duplicate rows from the table above.
My query is
SELECT *
FROM users
HAVING COUNT(*) > 1
The answer is
SELECT *
FROM users
GROUP BY id, name, created_at
HAVING COUNT(*) > 1
What is the difference between those 2 above?
I thought the COUNT aggregation is based on the all of the columns so I didn't add the "group by".