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

3 votes348 views1 answer
Sql case update
SQL
0 vote327 views1 answer
Alasql delete column
SQL
1 vote374 views1 answer
Hangfire clear all jobs
SQL
0 vote348 views1 answer
Cannot pip install mysqlclient
SQL
0 vote323 views2 answers
How to combine diff colmun value using group by postgres
SQL
0 vote372 views1 answer
Psql create usr
SQL
0 vote348 views1 answer
Create table like sql
SQL
3 votes334 views2 answers
Create schema postgres
SQL
1 vote325 views1 answer
Multiple count in sql
SQL
12 votes322 views1 answer
Script to add new column in table sql
SQL