Query to SELECT.

Forum Moderators: open

Message Too Old, No Replies

If `ip` occurs more than once in table

9:03 am on Dec 9, 2006 (gmt 0)

How can I SELECT all the rows that occur when `ip` occurs more than once in that table?

11:57 am on Dec 9, 2006 (gmt 0)

I dont have a database to test but I think its something like this:

SELECT IP, count(IP)
FROM table
WHERE count(IP) >1
GROUP BY IP

OR
SELECT IP, count(IP)
FROM table
GROUP BY IP
HAVING count(IP) >1

3:47 am on Dec 12, 2006 (gmt 0)

SELECT IP, count(IP)
FROM table
GROUP BY IP
HAVING count(IP) >1

Worked

3:48 am on Dec 12, 2006 (gmt 0)

Thanks