How to use SQL Server Select Distinct

How to use select distinct on one column, to eliminate duplicates

this short guide also goes on to show examples of how count distinct can be used to count unique records in a dataset, with simple examples

SQL Server Select Distinct and SQL Count Distinct can be really useful ways to identify duplicates and start to work out how to prevent duplicates from distorting your query results