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 vote152 views1 answer
File /etc/init.d/mysql not exists
SQL
4 votes212 views4 answers
Rollback in sql
SQL
2 votes204 views2 answers
Select list is not in group by clause
SQL
2 votes215 views2 answers
Mysql search for column name in all tables
SQL
0 vote211 views2 answers
How to display enum value sql server
SQL
0 vote256 views1 answer
Sql select without column name
SQL
24 votes212 views5 answers
Import dump mysql
SQL
0 vote210 views1 answer
How to close external sql connection in laravel
SQL
1 vote203 views1 answer
Mysql show table character set
SQL
12 votes205 views2 answers
Delete entries in postgresql
SQL