How to find 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

33 votes137 views6 answers
Change column name in mysql
SQL
0 vote139 views1 answer
Pl/ sql change currency
SQL
2 votes130 views4 answers
Duplicate record mysql
SQL
4 votes146 views5 answers
Primary key
SQL
1 vote134 views1 answer
Pl sql create table from another table
SQL
0 vote139 views1 answer
Get duplicate entry sql
SQL
1 vote157 views1 answer
Sample clause in sql
SQL
0 vote149 views1 answer
Insert value in identity
SQL
4 votes125 views2 answers
Postgresql reset sequence
SQL
0 vote146 views1 answer
Check if database exists sql
SQL