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

13 votes186 views1 answer
Views in sql
SQL
0 vote201 views1 answer
How to remove quotes from a string in ssis load file
SQL
1 vote259 views1 answer
Show databases mysql docker
SQL
0 vote177 views1 answer
Debian 10 install postgresql 2ndquadrant
SQL
0 vote182 views1 answer
Python mysql show databases
SQL
0 vote180 views1 answer
Mostrar datos de tablas relacionadas mysql kjava
SQL
0 vote201 views1 answer
Create query in where clasue
SQL
0 vote188 views1 answer
Php get closest location by latitude longitude
SQL
1 vote212 views1 answer
Postgres power
SQL
0 vote201 views1 answer
Connect postgresql using a connection string
SQL