Versions Compared

Old Version 3

changes.mady.by.user Brian Dixon

Saved on

compared with

New Version 4

changes.mady.by.user Jeremiah Sokolowski

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Code Block
languagesql
titleService Desk Cabling
linenumberstrue
SELECT COUNT(* FROM EQUIPMENT WHERE MAC_ADDRESS) CNT, IN
(SELECT MAC_ADDRESS
FROM EQUIPMENT E2
GROUP BY E2.MAC_ADDRESS
HAVING COUNT(E2.MAC_ADDRESS) > 1)