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 vote221 views1 answer
How to create a new shema using query languaage
SQL
6 votes219 views1 answer
Oracle trigger after logon on schema
SQL
6 votes217 views1 answer
Wordpress change user password sql
SQL
2 votes212 views1 answer
Sql count having
SQL
0 vote241 views1 answer
Rows, INSERT INTO, Returning
SQL
1 vote223 views1 answer
How to put value in variable mysql
SQL
39 votes230 views5 answers
Sql drop column
SQL
5 votes214 views3 answers
String concatenation sql server
SQL
0 vote196 views1 answer
Select value from previous row in postgresql
SQL
0 vote202 views1 answer
Zsh-syntax-highlighting zsh-autosuggestions
SQL