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 vote432 views1 answer
Split first name and last name in sql
SQL
0 vote349 views1 answer
An error occurred while installing mysql2 (0.5.3)
SQL
1 vote378 views1 answer
Group_concat order by
SQL
15 votes354 views4 answers
T-sql drop function if exists
SQL
12 votes401 views5 answers
Rename table in mysql
SQL
3 votes378 views1 answer
Postgresql today - 1 year
SQL
7 votes362 views3 answers
Sql fill table with info from anothe rtable
SQL
13 votes345 views4 answers
GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
SQL
2 votes352 views2 answers
How to get capital letter first in sql
SQL
0 vote333 views1 answer
Http://challenge01.root-me.org:58036/wsasd
SQL