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

3 votes214 views2 answers
SqlMessage: "Host '192.168.64.1' is not allowed to connect to this MariaDB server
SQL
3 votes222 views1 answer
Oracle undo tablespace schema
SQL
40 votes279 views4 answers
PostgreSQL add column
SQL
0 vote193 views1 answer
Replace multiple string in query sql
SQL
11 votes215 views1 answer
Sql insert multiple rows from select
SQL
2 votes217 views1 answer
Sql finding longest and shortest names in a fleld
SQL
0 vote215 views1 answer
How to increase the width of the screen in oracle
SQL
0 vote195 views1 answer
Sql server split string and insert into table select
SQL
0 vote334 views2 answers
Execute stored procedure without db set
SQL
0 vote203 views1 answer
How to save data in database in mysql node
SQL