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 vote296 views1 answer
Json_remove mysql
SQL
9 votes309 views4 answers
Last mysql
SQL
0 vote293 views1 answer
Changer un mot de passe mysql
SQL
0 vote305 views1 answer
Which MySQL data type to use for storing boolean values
SQL
1 vote308 views1 answer
Increase existing date in sql oracle
SQL
0 vote308 views1 answer
Sequelize postgresql schema
SQL
3 votes308 views3 answers
Create table in microsoft sql server
SQL
2 votes358 views1 answer
Postgresql group by month and year
SQL
0 vote301 views1 answer
Ora 00001 error catch plsql
SQL
1 vote301 views1 answer
Mysql limit results to 10
SQL