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 vote387 views1 answer
Mysql select row max date
SQL
4 votes337 views2 answers
Mysql show indexes on table
SQL
1 vote434 views1 answer
Postgresql Insufficient privilege: 7 ERROR: permission denied for table
SQL
0 vote374 views1 answer
Mysql 8 geo to json
SQL
16 votes335 views1 answer
CTE statement sql server
SQL
0 vote402 views1 answer
Create table using the clause with as
SQL
1 vote354 views1 answer
Oracle user last connected
SQL
26 votes360 views2 answers
Mysql workbench download
SQL
4 votes374 views3 answers
Sql drop database if exists
SQL
0 vote356 views1 answer
Hibernate with springboot mysql
SQL