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 vote215 views1 answer
Android sqlite get rows count
SQL
0 vote218 views1 answer
To change the database owner in SQL server
SQL
0 vote219 views1 answer
Sql server insert inner join
SQL
1 vote213 views1 answer
Add time to date sql
SQL
1 vote263 views1 answer
Delete mysql ubuntu 20.04
SQL
0 vote203 views1 answer
Sql revert migration
SQL
1 vote241 views2 answers
Mysql add column tinyint default 0
SQL
2 votes229 views2 answers
Sql percentage
SQL
0 vote243 views1 answer
Mysql change default collation
SQL
0 vote244 views1 answer
Sql script to remove default from column
SQL