sql get all column values distinct code example

Example 1: distincct sql

SELECT DISTINCT column1, column2, ...

 FROM table_name;

Example 2: how to select unique element in sql

DISTINCT
- select distinct * from employees; ==> 
  retrieves any row if it has at
  least a single unique column.

- select distinct first_name from employees; ==> 
      retrieves unique names
     from table. (removes duplicates)
     
- select distinct count(*) from employees;
     retrieve number of unique rows
     if any row has at least a single unique data.

Tags:

Sql Example

Related