How to check for duplicate column values in SQL?

Check duplicates in SQL using having clause

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