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 vote241 views1 answer
Drop check command
SQL
1 vote442 views2 answers
Sql unique rows
SQL
3 votes272 views1 answer
Sql case update
SQL
0 vote255 views1 answer
Arithmetic expression in sql
SQL
1 vote260 views2 answers
Changes not showing on website server odoo
SQL
0 vote259 views1 answer
Mysql get date diff in months
SQL
0 vote239 views1 answer
Generate sequence number in sql server
SQL
0 vote262 views1 answer
Find usage of table in sql server
SQL
8 votes265 views1 answer
Sql remove leading spaces
SQL
37 votes270 views5 answers
FIND DUPLICATES IN COLUMN SQL
SQL