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.

Similar codes

0 vote117 views1 answer
Bus source and destination equal to destination and source of another by sql query
SQL
0 vote171 views1 answer
Variable 'sql_mode' can't be set to the value of 'no_auto_create_user'
SQL
0 vote110 views1 answer
How to find username and password in oracle 18c
SQL
9 votes114 views3 answers
Sql delete where in
SQL
14 votes120 views4 answers
Sql compiler
SQL
2 votes114 views2 answers
Oracle multiple insert
SQL
8 votes115 views2 answers
Update sql server from another table
SQL
1 vote126 views1 answer
How to print longest name in sql
SQL
-1 vote109 views1 answer
Mysql case when multiple conditions
SQL
0 vote119 views1 answer
Criteria builder select subset of column
SQL