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 vote280 views1 answer
Synapse sql table set pk
SQL
0 vote284 views1 answer
Open postgresql.conf in centos
SQL
0 vote267 views1 answer
Inspecting a column unique/distinct values in SQL
SQL
5 votes300 views1 answer
Purge undo tablespace usage
SQL
1 vote289 views1 answer
OstgreSQL version
SQL
0 vote256 views1 answer
Parsing float to int in mysql
SQL
2 votes276 views1 answer
Get first n letter of department name in sql
SQL
20 votes305 views6 answers
Change password in mysql
SQL
1 vote274 views1 answer
Oracle activate job
SQL
0 vote305 views2 answers
Amazon linux postgresql client
SQL