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 vote334 views1 answer
Order by monthly in sql
SQL
1 vote359 views1 answer
Join first name and last name sql
SQL
1 vote358 views1 answer
Sql server cast date dd/mm/yyyy
SQL
0 vote353 views1 answer
Sql character index
SQL
0 vote345 views1 answer
Sql drop default
SQL
0 vote388 views1 answer
Snowflake drop column
SQL
0 vote336 views1 answer
Price-colour
SQL
2 votes353 views1 answer
Mysql last 7 days including today
SQL
0 vote364 views1 answer
Difference between min and max date sql
SQL
1 vote333 views1 answer
Sql delete all values in a column
SQL