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

0 vote186 views2 answers
Postgres isnull
SQL
0 vote153 views1 answer
Postgresql like
SQL
4 votes169 views3 answers
Is not null sql
SQL
1 vote127 views5 answers
Spring boot sql logging
SQL
0 vote160 views1 answer
Mysql make date from 2 column
SQL
7 votes179 views3 answers
Convert ansi sql
SQL
2 votes159 views4 answers
Mysql get all tables row count
SQL
0 vote170 views1 answer
Distance calculator from lat long sql query
SQL
2 votes180 views4 answers
Mysql select into new table
SQL
0 vote156 views1 answer
Mysql_num_fields in mysqli
SQL