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 vote124 views1 answer
Mysql remove last character
SQL
0 vote113 views1 answer
Oracle flush Shared Pool
SQL
0 vote133 views1 answer
Postgresql replace html tags from string
SQL
0 vote107 views1 answer
Python mysql query where
SQL
11 votes122 views2 answers
You are using safe update mode
SQL
16 votes116 views4 answers
Find duplicates mysql
SQL
0 vote120 views1 answer
Copy Table from SQL to CSV
SQL
0 vote111 views1 answer
Postgresql find missing id
SQL
0 vote169 views1 answer
ORA-01400
SQL
7 votes136 views2 answers
How to create index mysql
SQL