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 vote183 views1 answer
What is database username and password in mysqliconnect
SQL
8 votes170 views3 answers
Oracle auto_increment
SQL
3 votes185 views4 answers
Truncate syntax in sql
SQL
25 votes183 views4 answers
Sqlserver add column
SQL
14 votes180 views2 answers
Install mysqldump
SQL
0 vote188 views1 answer
Declaring variables in pl sql
SQL
17 votes187 views3 answers
Postgresql version command
SQL
0 vote167 views1 answer
Como saber si tengo mysql instalado
SQL
2 votes215 views1 answer
Sql string starts with
SQL
37 votes178 views3 answers
Duplicate records in sql
SQL