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

3 votes178 views3 answers
How to set up an auto incrementing id db browser
SQL
1 vote195 views1 answer
Check if mysql is installed
SQL
4 votes216 views4 answers
Mysql get date from datetime
SQL
1 vote179 views1 answer
Mysql get latest duplicate rows
SQL
0 vote183 views1 answer
Mssql describe stored procedure sqlcmd
SQL
3 votes232 views1 answer
Mysql group_concat distinct
SQL
7 votes183 views2 answers
Add column table pl sql
SQL
3 votes188 views4 answers
Order by desc postgres
SQL
0 vote205 views1 answer
Insert or update sql firebird
SQL
2 votes159 views2 answers
Mysql get last character of string
SQL