[ Get number os each duplicated items on table ]
I'm getting duplicate items of my table doing this:
SELECT * FROM table GROUP BY name HAVING COUNT(*) >1
It returns each duplicate item. But I would like to show:
"repeat X times".
How can I "echo" the "count" in this case?
You should show the
count(), instead of
select name, count(*) from table group by name having count(*) > 1;