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 vote358 views2 answers
How to install psql in ubuntu
SQL
3 votes313 views1 answer
Oracle get trigger ddl
SQL
0 vote320 views1 answer
Extract sql from query object sqlalchemy
SQL
5 votes333 views1 answer
AND OR NOT operators sql
SQL
1 vote279 views1 answer
Metada in sql
SQL
0 vote320 views1 answer
Flask sqlalchemy remove duplicates
SQL
0 vote262 views1 answer
Check if due date is less than todays date sql
SQL
0 vote351 views1 answer
Add new column in sql with foreign key
SQL
0 vote313 views1 answer
Sql developer sql worksheet not showing
SQL
0 vote309 views1 answer
Restore backupfile discourse
SQL