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

31 votes111 views4 answers
Mysql grant execute
SQL
3 votes130 views5 answers
Foreign keys
SQL
0 vote97 views1 answer
Sql transact create cursor with dynamic tables
SQL
16 votes109 views6 answers
Python sqlite
SQL
13 votes98 views2 answers
Sqlite rename column
SQL
14 votes104 views5 answers
Set password for postgres user ubuntu
SQL
6 votes133 views3 answers
Rename column ORACLE
SQL
0 vote96 views1 answer
Output table plsql
SQL
0 vote114 views3 answers
How to run sql query
SQL
3 votes94 views2 answers
Sql end of month
SQL