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 vote226 views1 answer
Stop and start mysql
SQL
3 votes170 views1 answer
Sql timestamp to date
SQL
0 vote174 views1 answer
Oracle list of long running queries
SQL
16 votes231 views2 answers
Sql vs nosql
SQL
0 vote188 views1 answer
How to drop a trigger in postgresql
SQL
0 vote182 views1 answer
Execute a stored procedure in another stored procedure in SQL server
SQL
1 vote178 views1 answer
Sql server select rows by distinct column
SQL
0 vote186 views1 answer
How to change mysql port in xampp
SQL
5 votes190 views2 answers
Create function postgresql
SQL
0 vote189 views1 answer
Oracle NLS_CHARACTERSET
SQL