How to check for duplicate column values in SQL?

By aj li

Check duplicates in SQL using having clause

Example:
Select LicenseNumber from Vehicle group by LicenseNumber having (count(LicenseNumber) > 1)

How to check for duplicate column values in SQL?  (1147 Views)