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 vote305 views1 answer
Convert rows into columns in oracle
SQL
0 vote312 views2 answers
The metadata storage is not up to date, please run the sync-metadata-storage command to fix this issue.
SQL
11 votes362 views1 answer
Oracle insert from select
SQL
0 vote316 views1 answer
Connexion mysql
SQL
-1 vote309 views1 answer
Ssql to lowercqse
SQL
2 votes315 views1 answer
Sql missing records from another table
SQL
0 vote272 views1 answer
How to get last client id sql
SQL
3 votes317 views2 answers
Brew restart mysql
SQL
14 votes332 views3 answers
Trim sql
SQL
22 votes347 views3 answers
Year format in date mysql
SQL