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 vote216 views1 answer
Mysql select all where count more than"
SQL
0 vote200 views1 answer
Sql change default collation to utf8
SQL
0 vote192 views1 answer
Sum value by month sql
SQL
0 vote196 views1 answer
Sql developer search all packages for text
SQL
1 vote226 views2 answers
Sqlstate[hy000]: general error: 1005 can't create table (errno: 150 "foreign key constraint is incorrectly formed")
SQL
0 vote224 views1 answer
C# sql transaction multiple connections
SQL
0 vote256 views1 answer
Postgres get running query
SQL
0 vote209 views1 answer
Docker open terminal mysql server
SQL
0 vote366 views1 answer
Running mysql from bash sc
SQL
0 vote161 views1 answer
Mariadb list tables
SQL