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 vote173 views1 answer
Mariadb alter table add column if not exists example
SQL
0 vote205 views3 answers
Sql parenthetical expression examples
SQL
0 vote186 views1 answer
Mssql + bit + in python orm
SQL
10 votes239 views4 answers
Sql server pagination
SQL
0 vote182 views1 answer
Rabbitmq ui not working
SQL
1 vote171 views1 answer
How to select rows with no matching entry in another table?
SQL
0 vote174 views1 answer
Get role postgres
SQL
5 votes167 views1 answer
Oracle get nls settings
SQL
0 vote183 views1 answer
Shows all databases created by user in ms sql
SQL
0 vote259 views1 answer
SQL query to verify the size of the table
SQL