We can get unique records from the column with the help of DISTINCT. Use of DISTINCT in our query will return only the unique set of records, which means any duplicate entry will be shown only once. For example, to get only the unique locations of all the employees in an organization, we can use – SELECT DISTINCT location FROM employees;