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 vote184 views2 answers
Mysql unique two columns
SQL
0 vote187 views1 answer
Sql case sttement with set
SQL
0 vote170 views1 answer
Database springboot
SQL
2 votes172 views1 answer
Mysql select random id from table
SQL
1 vote190 views1 answer
Random name function in mysql for nvarchar
SQL
0 vote176 views1 answer
Minecraft duping allowed servers
SQL
0 vote175 views1 answer
Oracle select invalid views
SQL
6 votes175 views1 answer
Sqlite foreign key
SQL
0 vote202 views1 answer
T sql dynamic top n query
SQL
0 vote154 views1 answer
Alter session set nls_language french
SQL