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

0 vote218 views1 answer
How to compile a function in oracle
SQL
0 vote185 views1 answer
Query to count the number of rows in a table in sqlalchemy
SQL
0 vote208 views1 answer
Cahnge column name apex oracle
SQL
20 votes189 views5 answers
Sql show tables
SQL
5 votes209 views2 answers
Add days in oracle sql
SQL
29 votes178 views6 answers
Delete all rows from table mysql
SQL
3 votes192 views2 answers
Wp do sql query from function
SQL
1 vote190 views1 answer
Moodle query first user access
SQL
1 vote186 views2 answers
Test sqlsrv connection
SQL
0 vote192 views1 answer
What does leave do in mysql
SQL