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 vote309 views1 answer
Insert output identity
SQL
0 vote309 views1 answer
Postgresql using reserved word as column name
SQL
0 vote299 views1 answer
Oracle gather table statistics
SQL
0 vote317 views1 answer
Split string by comma in sql server
SQL
0 vote303 views1 answer
Lesser than or equal to symbol in postgres
SQL
0 vote322 views2 answers
Starts and end with vowel sql
SQL
0 vote319 views1 answer
Search mysql database for column
SQL
0 vote300 views1 answer
Kotlin sqlite delete row
SQL
4 votes305 views1 answer
Describe table mysql
SQL
5 votes329 views3 answers
DBMS_OUTPUT.PUT_LINE
SQL