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

6 votes194 views2 answers
Oracle compile trigger
SQL
1 vote132 views1 answer
Oracle compile schema
SQL
0 vote168 views1 answer
Mysql drop vs delete
SQL
1 vote144 views1 answer
Oracle truncate partition
SQL
0 vote143 views1 answer
Incorrect datetime value sql table error 1292
SQL
2 votes181 views1 answer
Datetrunc
SQL
2 votes181 views1 answer
Python sql
SQL
1 vote147 views1 answer
Reutrn string after character sql
SQL
1 vote188 views1 answer
Create sqlite database in laravel
SQL
3 votes245 views1 answer
Oracle show trigger code
SQL