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 vote150 views1 answer
Run docker container with database as rds metabase
SQL
3 votes109 views3 answers
Create table in microsoft sql server
SQL
5 votes107 views2 answers
Oracle to_timestamp
SQL
0 vote113 views1 answer
How to convert DateTime to VarChar SQL
SQL
0 vote110 views1 answer
Adonisjs ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client
SQL
4 votes126 views3 answers
Mysql get column names from table
SQL
1 vote132 views2 answers
Mysql extract number from string
SQL
0 vote117 views1 answer
Sql show all users
SQL
1 vote125 views1 answer
Update mysql centos
SQL
3 votes114 views1 answer
Oracle drop user
SQL