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 vote67 views1 answer
Insert and initialize a SQL column with value dependent on another column data
SQL
5 votes113 views5 answers
Find max number in sql
SQL
0 vote135 views2 answers
How to see table associated with a schema in sql
SQL
0 vote140 views1 answer
Sql count total by foreign key
SQL
-1 vote143 views1 answer
Add 10 to all numbers in a column sql
SQL
0 vote120 views1 answer
Psql list view rules
SQL
24 votes122 views4 answers
Postgres remove database
SQL
18 votes116 views6 answers
Drop table if exists
SQL
0 vote109 views1 answer
Distinct data types in a table sql query
SQL
1 vote124 views1 answer
Postgresql update auto_increment value
SQL