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

2 votes287 views1 answer
Sql server find columns list in tables
SQL
0 vote296 views1 answer
Mysql order by rand limit 1 really slow
SQL
5 votes232 views1 answer
Postgres upsert
SQL
1 vote260 views1 answer
Set all the vluses in calumn in sql to false
SQL
0 vote263 views1 answer
Except in sql alchemy
SQL
1 vote265 views1 answer
Host 127.0 0.1 is not allowed to connect to this mysql server
SQL
0 vote263 views1 answer
Recover deleted data from mysql database
SQL
4 votes309 views4 answers
Mysql get date from datetime
SQL
0 vote303 views1 answer
Combine 2 columns search query mysql
SQL
0 vote258 views1 answer
Como hacer una consulta en sql
SQL