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

23 votes270 views6 answers
Delete all rows from table sql
SQL
5 votes283 views1 answer
Mysql created at yesterdau
SQL
3 votes308 views2 answers
Oracle sql first day of month
SQL
1 vote268 views1 answer
Search for tables with name postgresql
SQL
1 vote292 views1 answer
Date_part mysql
SQL
0 vote253 views1 answer
Declaring variables in pl sql
SQL
8 votes269 views1 answer
Insert a select statement into a table
SQL
0 vote259 views1 answer
Sql compound operators
SQL
1 vote306 views1 answer
Sql view where tables have same column name combine results
SQL
7 votes271 views4 answers
Database dump mysql command
SQL