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

2 votes153 views1 answer
Capitalize 1st letter in sql server
SQL
0 vote177 views1 answer
Copy from one table to another postgres using matching column
SQL
1 vote143 views1 answer
Pl sql ptint
SQL
1 vote155 views1 answer
Import mysql dump database command line linux
SQL
5 votes137 views1 answer
Oracle ORA-00054 origin
SQL
0 vote132 views1 answer
Allow all local clients (local socket connections) to connect to the kodekloud_db1
SQL
0 vote138 views1 answer
Java mysql date format
SQL
5 votes146 views3 answers
Oracle list columns in schema
SQL
0 vote144 views1 answer
Mysql shell set time_zone
SQL
7 votes159 views3 answers
Can't connect to local mysql server through socket '/tmp/mysql.sock' (2)
SQL