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

1 vote99 views1 answer
Oracle select first result
SQL
0 vote116 views1 answer
SQL server datetime compare
SQL
0 vote104 views1 answer
Microsoft word insert sql code
SQL
8 votes124 views2 answers
How to fetch data from database without last column
SQL
0 vote120 views1 answer
Play framework connection via windows sql server
SQL
0 vote149 views1 answer
Postgres extract number from string
SQL
0 vote97 views1 answer
Sql random decimal
SQL
0 vote216 views2 answers
Illuminate\Database\QueryExceptionSQLSTATE[HY000] [2002] No such file or directory
SQL
0 vote105 views1 answer
Shrink database file in sql server
SQL
1 vote108 views1 answer
Median mysql
SQL