Sql query unique

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.

Source: grepper.com

Sql unique select

SELECT DISTINCT col1, col2, ....
FROM table_name;

SELECT col1, MIN(col2)
FROM table_name
GROUP BY col1;

Source: grepper.com

Similar codes

1 vote107 views1 answer
Incompatible sql_mode=only_full_group_by
SQL
9 votes111 views2 answers
Mac mysql this is incompatible with sql_mode=only_full_group_by
SQL
0 vote108 views1 answer
Difference between min and max date sql
SQL
3 votes106 views1 answer
V$session not found in oracle
SQL
0 vote100 views1 answer
Difference between varchar and varchar2
SQL
0 vote109 views1 answer
Mysql workbench not showing schemas
SQL
7 votes115 views3 answers
Convert ansi sql
SQL
38 votes184 views6 answers
Ubuntu install mysql client
SQL
2 votes104 views2 answers
Exec procedure pl sql
SQL
0 vote102 views1 answer
Group by two columns postgres
SQL