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

10 votes210 views2 answers
Tsql merge example
SQL
0 vote194 views1 answer
Mysql group by range
SQL
1 vote194 views1 answer
Pentaho + pasar de excel a sql
SQL
0 vote196 views1 answer
Sequelize postgresql schema
SQL
0 vote187 views1 answer
Check if table exists oracle
SQL
0 vote194 views1 answer
Copy data from one postgres container to another
SQL
9 votes220 views3 answers
Postgres make sql dump
SQL
1 vote185 views2 answers
How to check username in mysql command line
SQL
23 votes205 views3 answers
Sql where contains part of string
SQL
1 vote198 views1 answer
Postgres power
SQL