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 vote221 views1 answer
Bash block size ls /var/lib/mysql
SQL
25 votes229 views1 answer
Mysql grant all privileges to a user
SQL
0 vote233 views1 answer
Check sql database table lock
SQL
2 votes243 views2 answers
Postgres select duplicate columns
SQL
0 vote251 views1 answer
Sqlite trim
SQL
3 votes231 views5 answers
Mysql get last inserted id
SQL
6 votes254 views3 answers
Mysql create database utf8
SQL
0 vote235 views1 answer
Sql create table with references not primary key
SQL
0 vote267 views2 answers
Clauses in mysql
SQL
0 vote247 views1 answer
Sql declare variable single line
SQL