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

16 votes407 views6 answers
Mysql find duplicates in same table
SQL
13 votes373 views2 answers
Sql online compiler
SQL
1 vote348 views1 answer
Oracle db create new schema
SQL
0 vote331 views1 answer
Duplicate foreign key constraint name
SQL
0 vote348 views1 answer
Mysql get 2nd value in comma separated list
SQL
0 vote381 views1 answer
Databricks install odbc driver connect to sql server
SQL
0 vote352 views2 answers
Mysql select date from datetime
SQL
1 vote366 views4 answers
Psql: error: FATAL: database "odoo" does not exist
SQL
1 vote349 views1 answer
Mysqlworkbench Your connection attempt failed for user 'root' from your host to server at 127.0.0.1:3306: Authentication plugin 'caching_sha2_password' cannot be loaded: dlopen(/usr/local/mysql/lib/plugin/caching_sha2_password.so, 2): image not found
SQL
0 vote351 views1 answer
SqlFunction does not exist
SQL