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

10 votes264 views2 answers
Doublon sql
SQL
0 vote190 views1 answer
Insert value in identity
SQL
0 vote133 views1 answer
Postgres delete where id in
SQL
1 vote169 views1 answer
Postgres convert exisiting column to text
SQL
2 votes170 views1 answer
Oracle sql drop column if exists
SQL
1 vote178 views1 answer
Postgres delete from where date is greater than specific date
SQL
0 vote169 views1 answer
Add alternate add column sql
SQL
0 vote171 views1 answer
Group by join columns per table
SQL
0 vote170 views2 answers
Sql query inner join 3 tables
SQL
2 votes190 views1 answer
Mysql select true or false
SQL