...
Duplicate MAC Address LocatorĀ for Oracle and MySQL
Service Desk Cabling
Code Block | ||||||
---|---|---|---|---|---|---|
| ||||||
SELECT * FROM EQUIPMENT WHERE MAC_ADDRESS IN (SELECT MAC_ADDRESS FROM EQUIPMENT E2 GROUP BY E2.MAC_ADDRESS HAVING COUNT(E2.MAC_ADDRESS) > 1) |
...
...
Code Block | ||||||
---|---|---|---|---|---|---|
| ||||||
SELECT * FROM EQUIPMENT WHERE MAC_ADDRESS IN (SELECT MAC_ADDRESS FROM EQUIPMENT E2 GROUP BY E2.MAC_ADDRESS HAVING COUNT(E2.MAC_ADDRESS) > 1) |
...