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 vote156 views2 answers
Postgresql variable in query
SQL
0 vote166 views2 answers
Impala rename column name
SQL
21 votes139 views6 answers
Change column in mysql
SQL
1 vote139 views1 answer
Sql upsert
SQL
0 vote168 views1 answer
Uncheck constraints and delete from table
SQL
1 vote152 views1 answer
Where not in array sql
SQL
2 votes137 views1 answer
Oracle cpu per session
SQL
0 vote177 views1 answer
Zsh: command not found: mysql mamp
SQL
0 vote175 views1 answer
Mssql find deadlocks
SQL
1 vote197 views2 answers
Mysql SELECT
SQL