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 vote323 views1 answer
Oracle string substitution
SQL
0 vote344 views1 answer
How to find the most occuring in SQL
SQL
2 votes306 views1 answer
Sqlite show table indexes
SQL
7 votes313 views1 answer
Query delete duplicates
SQL
0 vote332 views1 answer
Get rows from 1 table with other table empty mysql
SQL
0 vote323 views1 answer
Sql trigger to call stored procedure with parameters
SQL
0 vote329 views2 answers
Call to undefined function mysqli_fetch_all()
SQL
0 vote314 views1 answer
Postgres 11 add primary key
SQL
1 vote338 views1 answer
Mysql show attributes of a table
SQL
0 vote346 views1 answer
Suhaib
SQL