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

19 votes126 views2 answers
Mysql add column after another
SQL
4 votes132 views1 answer
Postgres delete last row
SQL
0 vote157 views1 answer
Sqlite3 pragma foreign keys
SQL
0 vote135 views1 answer
Joomla execute raw sql
SQL
0 vote141 views1 answer
Drop table BigQuery table columns
SQL
1 vote123 views1 answer
Sql delete row with auto increment
SQL
0 vote175 views1 answer
Capabilities of sql select statements
SQL
0 vote128 views1 answer
Apt install sql server
SQL
3 votes118 views2 answers
Postgres download
SQL
3 votes134 views1 answer
Sql server check version
SQL