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

-1 vote194 views1 answer
Round up and down sql
SQL
5 votes216 views3 answers
MySql get fields of table
SQL
0 vote235 views1 answer
Postgres execute multiple sql file from command line
SQL
9 votes203 views4 answers
Mysql show table fields
SQL
0 vote157 views2 answers
Avg() sql
SQL
0 vote214 views1 answer
How to inner join 4 tables in sql
SQL
3 votes198 views1 answer
Oracle APEX elapsed time
SQL
0 vote240 views1 answer
Mysql random number between 1 and 100
SQL
2 votes235 views2 answers
Postgres change owner of schema
SQL
0 vote209 views1 answer
Sql last 3 rows
SQL