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 vote152 views1 answer
Sql server information_schema temp tables
SQL
4 votes144 views1 answer
Postgresql create table with index
SQL
0 vote128 views1 answer
View t-sql mail configuration
SQL
0 vote135 views1 answer
Yesql
SQL
13 votes134 views3 answers
Sql online code
SQL
10 votes122 views1 answer
Dba_dependencies
SQL
5 votes123 views1 answer
Sql select ciunt
SQL
2 votes117 views1 answer
How to delete columns in sql
SQL
1 vote134 views1 answer
Type int in mysql maxlenght
SQL
1 vote137 views1 answer
Postgresql define pk sequence next number
SQL