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 vote192 views1 answer
Postgresql if else endif
SQL
0 vote189 views1 answer
Create schema sql server
SQL
1 vote196 views2 answers
Mysql between
SQL
0 vote238 views1 answer
Fetcht he leftmost word in a comma separated string in sql
SQL
0 vote225 views1 answer
Mariadb.service failed with result 'exit-code'
SQL
1 vote404 views1 answer
How to make a select in sql
SQL
0 vote188 views1 answer
Mysql DDL
SQL
8 votes140 views2 answers
Alter column name in mssql
SQL
0 vote225 views1 answer
Postgres truncate with cascade
SQL
5 votes196 views4 answers
Change auto increment mysql
SQL