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 vote150 views1 answer
Drop view in mysql
SQL
0 vote149 views1 answer
Bitmap join index
SQL
1 vote139 views1 answer
Psql show with user is logged in
SQL
0 vote145 views1 answer
Oracle get running queries
SQL
0 vote143 views1 answer
Spark sql grows beyond 64 kb
SQL
1 vote146 views1 answer
Altering the column name in MySQL to have a default value
SQL
0 vote146 views1 answer
Configure: error: Cannot find libpq-fe.h. Please specify correct PostgreSQL installation path
SQL
7 votes173 views1 answer
Oracle pagination query rownum
SQL
0 vote167 views1 answer
Mariadb change column type
SQL
2 votes188 views3 answers
3 days back in sql server
SQL