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 votes113 views1 answer
Mysql list users on ubuntu
SQL
1 vote124 views3 answers
Execute sp in sql server
SQL
1 vote119 views1 answer
How to test for sql injection
SQL
50 votes194 views4 answers
Sql alter type of column
SQL
0 vote132 views1 answer
Add unique constraint sql server multiple columns
SQL
0 vote123 views1 answer
Drop all tables db2
SQL
19 votes128 views6 answers
What is mySQL
SQL
1 vote136 views1 answer
Create sqlite database in laravel
SQL
0 vote114 views1 answer
Alter table add foreign key mariadb example
SQL
1 vote118 views1 answer
Media sql
SQL