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

1 vote186 views2 answers
Postgresql truncate cascade restart identity
SQL
0 vote224 views1 answer
Jooq replace
SQL
1 vote164 views1 answer
What is intersect
SQL
1 vote174 views2 answers
How to search date in sql query
SQL
3 votes161 views1 answer
Two selects in one query
SQL
0 vote217 views1 answer
Which lock mode is not available in sql
SQL
0 vote122 views1 answer
Mssql view column data type
SQL
14 votes169 views5 answers
Sql oracle limit
SQL
0 vote171 views1 answer
How to get specific salary in sql
SQL
5 votes208 views1 answer
Oracle columns in all_tables
SQL