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 vote288 views3 answers
Group_concat sql server
SQL
0 vote355 views1 answer
Error Code: 1267. Illegal mix of collations (latin1_general_ci,IMPLICIT) and (latin1_swedish_ci,IMPLICIT) for operation '=' 0.000 sec
SQL
8 votes349 views2 answers
Default sql server port
SQL
0 vote300 views1 answer
What alter does in db
SQL
0 vote293 views1 answer
How to put value in parameters in mysqldataadapter
SQL
0 vote300 views4 answers
Mysql count table rows
SQL
5 votes301 views1 answer
Mysql count newlines in field
SQL
0 vote299 views1 answer
Mysql shell ERROR: Not connected.
SQL
7 votes269 views2 answers
Create mysql user
SQL
0 vote300 views1 answer
Set classpath for mysql-connector.jar
SQL