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 vote176 views2 answers
Msg 8164, Level 16, State 1, Procedure getSalaryMonth, Line 31 [Batch Start Line 13] An INSERT EXEC statement cannot be nested.
SQL
0 vote186 views1 answer
Second Step in installing SQL workbench
SQL
0 vote173 views1 answer
Mysql table variables
SQL
-1 vote167 views3 answers
SQL to LINQ converter
SQL
0 vote129 views0 answer
SQL
0 vote172 views1 answer
Copy row from db to db mysql
SQL
62 votes191 views8 answers
Mysql add column
SQL
2 votes184 views1 answer
Compare date in sql
SQL
0 vote178 views1 answer
Oracle synonym procedure dblink
SQL
0 vote175 views1 answer
Firebird where
SQL