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 vote226 views1 answer
Hw to delete a procedure in pl sql
SQL
1 vote261 views2 answers
Sql split string by space
SQL
0 vote264 views1 answer
Get substract count sql
SQL
0 vote223 views1 answer
Original Query
SQL
-1 vote227 views1 answer
Install mysql 5.7 ubuntu 20.04
SQL
0 vote229 views1 answer
Mysql foreach insert
SQL
0 vote235 views3 answers
Sql query checker
SQL
0 vote243 views1 answer
How to get nth number in sql
SQL
1 vote219 views1 answer
Show table status command in mysql
SQL
3 votes216 views2 answers
How to View column names of a table in SQL
SQL