select ip, mac from ipmac group by mac having count(*) > 1;
> I have a table with IP/MAC address combinations and I want to track
> which MAC address might have used an IP address other than the one
> originally assigned.
>
> Is there some way that I can query my table for duplicate MAC
> addresses without specifying a MAC address.
>
> In plain english the query would be something like:
> select ip, mac from ipmac where the same mac appears in more than
> one row
>
> But how to write the proper sql is my problem. Thanks for any help.
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
