Displaying rows with duplicate username

[Anon]

I have a table that has a column for usernames etc and I need to find a query that displays all the rows that have more than X duplications of the username

Like I need the info from all the rows that have > 3 entries from the same user

What kinda works is
SELECT
FROM table
GROUP BY username
HAVING COUNT()>3;

This is exactly what I need except I need it to show every row and that is only showing one row with that username.

Thanks,

Warren

[Anon]

If you are using a database that can do sub-queries, then change your statement to:

SELECT
FROM table
WHERE username IN (
SELECT username
FROM table
GROUP BY username
HAVING count() > 3)
GROUP BY username;

This won't be the fastest of queries, but it should get you the information that you are looking for.