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

2 votes185 views2 answers
Mysql bidirectional composite primary key
SQL
0 vote184 views1 answer
Sql select min
SQL
9 votes199 views6 answers
Sql add column with default value
SQL
1 vote174 views1 answer
Crontab every month
SQL
0 vote183 views1 answer
Sqlite commands
SQL
1 vote194 views1 answer
Sql server kill all connections
SQL
0 vote195 views1 answer
Sql get year from datetime field
SQL
1 vote182 views1 answer
Oracle apex run 404
SQL
0 vote181 views1 answer
Mysql count unique in group statement
SQL
0 vote143 views2 answers
Https://www.google.com/search?ei=bihqX_v9DJb--gTYoLH4DQ
SQL