select distinct

SQL SERVER DISTINCT keyword is used to remove all the duplicate records and fetching only unique records from any table.