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 vote223 views1 answer
Sql sum if
SQL
2 votes198 views2 answers
Exec procedure pl sql
SQL
1 vote219 views2 answers
Get table column names sql laravel
SQL
6 votes197 views1 answer
Oracle desc table primary key
SQL
1 vote259 views1 answer
Hangfire clear all jobs
SQL
0 vote202 views1 answer
Uuid sqlalcomany
SQL
0 vote183 views1 answer
Mysql does collate nopad recognize space
SQL
1 vote218 views1 answer
Expression number 1 of select list is not in group by clause
SQL
0 vote197 views1 answer
How to check default value of column in sql server
SQL
31 votes210 views3 answers
SQL Server change column data type
SQL