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 vote278 views1 answer
Connecting mySQL to STS
SQL
0 vote276 views1 answer
Less than and between in sql query
SQL
0 vote294 views1 answer
T-sql email validation
SQL
0 vote280 views1 answer
Sql server create constraint
SQL
0 vote303 views1 answer
Dockerfile example for Django
SQL
2 votes264 views1 answer
Enum in SQL Server
SQL
0 vote281 views1 answer
Createdb with postgresql on ubuntu
SQL
-1 vote290 views2 answers
Sql truncate number
SQL
0 vote270 views1 answer
Test connection to sql server
SQL
1 vote279 views1 answer
Join first name and last name sql
SQL