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 vote135 views5 answers
Linq cheat sheet
SQL
5 votes138 views1 answer
Mysql count lines
SQL
244 votes255 views14 answers
Sql n insert
SQL
0 vote161 views1 answer
Postgressql uuid
SQL
0 vote137 views1 answer
Change schema of all tables postgres
SQL
23 votes140 views4 answers
How to show all users in mysql
SQL
1 vote183 views1 answer
Show databases mysql docker
SQL
0 vote91 views1 answer
How to connect sql server using ip address in c#
SQL
1 vote167 views3 answers
How to create a table structure from another table in mysql
SQL
17 votes135 views6 answers
Sql select distinct
SQL