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 vote277 views1 answer
Which MySQL data type to use for storing boolean values
SQL
1 vote528 views1 answer
Mysql event last execution
SQL
4 votes283 views2 answers
Mysql alter table set column unique
SQL
0 vote197 views1 answer
Oracle array
SQL
8 votes230 views1 answer
Racle create auto increment column
SQL
0 vote234 views1 answer
Time in sql server
SQL
3 votes221 views3 answers
1396(hy00) mysql error
SQL
0 vote223 views1 answer
Sql today at midnight
SQL
10 votes145 views2 answers
Django mysql
SQL
0 vote193 views1 answer
Fill up postgres db
SQL