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 vote115 views1 answer
Select a row include list of array with join table SQL
SQL
7 votes113 views1 answer
Postgres base size
SQL
2 votes118 views2 answers
Maximum execution time of 360 seconds exceeded
SQL
-1 vote123 views3 answers
Psql get last rows
SQL
0 vote113 views1 answer
Resulting Query
SQL
0 vote131 views1 answer
How to create a new db from dumb file mysql
SQL
0 vote121 views1 answer
Python mysql query to dataframe
SQL
3 votes120 views1 answer
Oracle user quota on tablespace
SQL
39 votes183 views4 answers
Select duplicates in sql
SQL
0 vote112 views1 answer
Sql last 7 days
SQL