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

6 votes238 views2 answers
What is non relational database
SQL
2 votes234 views1 answer
Sql skip the first row
SQL
0 vote230 views1 answer
Django mssql backend
SQL
0 vote245 views1 answer
How to check database engine in mysql
SQL
15 votes238 views4 answers
Mysql export database command line
SQL
1 vote235 views2 answers
Oracle list service names
SQL
0 vote229 views2 answers
How to relationship query two different tables in MySQL
SQL
1 vote231 views1 answer
Postgresql create table with timestamp
SQL
2 votes229 views2 answers
How to create an empty table from an existing table
SQL
2 votes238 views1 answer
Drop sequence
SQL