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

0 vote193 views1 answer
Oracle last character of string
SQL
0 vote220 views2 answers
MySQL PARTITION BY month automatically
SQL
0 vote193 views1 answer
How to check xampp mysql password
SQL
0 vote193 views1 answer
Oracle shrink table
SQL
0 vote179 views1 answer
Count the table indatabase
SQL
12 votes192 views2 answers
Delete all nodes neo4j
SQL
6 votes208 views3 answers
Error Code: 1055. Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'mydb.term.year' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
SQL
1 vote196 views1 answer
Sql how to duplicate a table
SQL
0 vote195 views2 answers
Mysql update two tables at once
SQL
0 vote219 views1 answer
To Create directory
SQL