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

4 votes262 views2 answers
How to insert ip address in mysql using php
SQL
0 vote294 views1 answer
Postgre query date
SQL
3 votes264 views1 answer
Sql server version query
SQL
0 vote272 views2 answers
Sqlite unique
SQL
0 vote270 views1 answer
How to change null display in psql
SQL
0 vote303 views3 answers
Select top 10 rows in sql
SQL
0 vote271 views1 answer
Subquery aggregation
SQL
18 votes268 views4 answers
Mysql current date between two dates
SQL
0 vote252 views1 answer
Sql string length postgresql
SQL
0 vote284 views1 answer
SQLSTATE[42S02]: Base table or view not found: 1146 Tabl
SQL