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 vote151 views2 answers
Call to undefined function mysql_query()
SQL
1 vote127 views1 answer
How much every mysql database record takes from diskspace
SQL
0 vote132 views1 answer
Kill a pid redshift
SQL
2 votes128 views2 answers
Join update query in sql
SQL
0 vote140 views1 answer
How to reset the database value in SQL server
SQL
8 votes124 views1 answer
Alter tablespace add datafile
SQL
1 vote161 views1 answer
Oracle check table lock
SQL
1 vote1.8K views1 answer
Dropping a constraint in ms sql
SQL
0 vote85 views1 answer
Sql query with date
SQL
0 vote133 views2 answers
Don't know how to set rpath on your system, if MySQL libraries are not in path mysql2 may not load
SQL