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 vote101 views1 answer
Docker ERROR 2003 (HY000): Can't connect to MySQL server on '127.0.0.1' (61)
SQL
0 vote99 views1 answer
Java sql insert return id
SQL
0 vote94 views1 answer
Sql where time stamp is in between
SQL
1 vote103 views1 answer
Sql select where id not exists in another table
SQL
0 vote134 views1 answer
How to get table id sequence postgres
SQL
0 vote99 views1 answer
Insert into using contant values and source table columns with sql
SQL
3 votes96 views1 answer
Oracle APEX elapsed time
SQL
1 vote110 views1 answer
Print year of a date sql
SQL
17 votes103 views3 answers
Cast in sql server
SQL
0 vote107 views1 answer
How to put value in parameters in mysqldataadapter
SQL