Sql unique rows

SELECT
DISTINCT country
FROM City;

Source: learnsql.com

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

6 votes343 views3 answers
Mysql first day of year
SQL
2 votes368 views1 answer
Can you use a where clause for a child query
SQL
0 vote342 views2 answers
Laravel: customize or extend notifications - database model
SQL
11 votes395 views2 answers
Having clause in sql
SQL
0 vote336 views1 answer
Access denied for user 'root'@'localhost' workbench ubuntu
SQL
1 vote401 views1 answer
Encrypt password postgresql
SQL
0 vote343 views1 answer
Postgres declare variable
SQL
7 votes350 views1 answer
Connect mysql docker
SQL
24 votes388 views4 answers
Postgres delete database
SQL
0 vote373 views1 answer
Flush user resource mysql
SQL