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 vote176 views1 answer
R2dbc-postgresqldriver dependency
SQL
13 votes194 views4 answers
What is sql
SQL
0 vote185 views1 answer
Laravel general error 2006 mysql server has gone away
SQL
0 vote149 views1 answer
Get last run query sql server
SQL
1 vote187 views1 answer
Job for mariadb.service failed because the control process exited with error code. see "systemctl status mariadb.service" and "journalctl -xe" for details.
SQL
0 vote232 views1 answer
Update database collation in postgresql
SQL
0 vote180 views1 answer
Date datatype in livesql
SQL
0 vote139 views1 answer
How to set field to null in sql
SQL
17 votes206 views5 answers
Order by sql
SQL
0 vote226 views1 answer
Which takes more space in a database a datetime or separate date and time columns?
SQL