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 vote260 views1 answer
Update if else mysql
SQL
1 vote394 views1 answer
Cannot define PRIMARY KEY constraint on nullable column in table 'Student'.
SQL
1 vote270 views1 answer
Mysql show database size in mb
SQL
1 vote290 views1 answer
Set id count mysql
SQL
0 vote256 views1 answer
Select from another database
SQL
1 vote260 views1 answer
Postgresql last element of array
SQL
6 votes305 views2 answers
Install psql mac
SQL
0 vote278 views1 answer
SqlMessage: "Table 'Friends' already exists",
SQL
0 vote276 views1 answer
Oracle concat datetime
SQL
0 vote264 views4 answers
Change schema in sql server
SQL