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 vote331 views1 answer
Drop all data from tables
SQL
6 votes311 views1 answer
Oracle trigger after connect
SQL
1 vote324 views1 answer
Create sample data postgresql
SQL
-1 vote334 views1 answer
Add column alter table default value
SQL
10 votes366 views1 answer
Oracle view dependencies
SQL
0 vote363 views1 answer
Python sql passer des parametres dans une requet pymysql
SQL
0 vote328 views3 answers
Convert sql query to python pandas
SQL
0 vote425 views1 answer
Oracle simple quote
SQL
5 votes346 views2 answers
Create function postgresql
SQL
5 votes359 views2 answers
To date oracle
SQL