I'm trying to select the duplicates of the ID field. The script I've written works fine for finding any of the other fields except the ID field. Why does it work for all other fields and not for the ID field? I have even tried to alias the ID field, but to no avail. Any help would be greatly appreciated.

This works:
SELECT Email, COUNT(*) as 'Number Duplicates'
FROM Users
GROUP BY Email
HAVING COUNT(*) > 1


This doesn't:
SELECT ID, COUNT(*) as 'Number of Duplicates'
FROM Users
GROUP BY [ID]
HAVING COUNT(*) > 1


Thanks...