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

5 votes332 views1 answer
Commentaire table oracle
SQL
0 vote343 views1 answer
Sql alter table add column if exists
SQL
0 vote345 views1 answer
Print boolean in plsql
SQL
1 vote338 views4 answers
Psql: error: FATAL: database "odoo" does not exist
SQL
14 votes339 views3 answers
This is incompatible with sql_mode=only_full_group_by laravel
SQL
1 vote342 views3 answers
How to filter repeated same result using sql query
SQL
26 votes275 views10 answers
Insert in to table sql
SQL
10 votes353 views4 answers
Else if mysql
SQL
0 vote325 views1 answer
Tsql find procedure with name
SQL
3 votes323 views1 answer
Oracle apex warn on unsaved changes
SQL