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 vote284 views1 answer
Jdbc sql connection string
SQL
29 votes288 views5 answers
Mysql show table structure
SQL
11 votes270 views2 answers
Having keyword sql
SQL
1 vote342 views1 answer
How not to sort by average rating
SQL
1 vote328 views2 answers
How to install mysql workbench in ubuntu 20.04
SQL
0 vote298 views1 answer
What is between keyword used for
SQL
2 votes268 views1 answer
Mysql sysdate
SQL
0 vote288 views1 answer
Sql delete row from table where id
SQL
1 vote291 views2 answers
How to check if sql query is correct online
SQL
2 votes310 views2 answers
Get all tables using like
SQL