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 vote334 views1 answer
Sql inserted
SQL
0 vote353 views1 answer
Convert int to varchar sql
SQL
0 vote370 views1 answer
Node-pre-gyp ERR! Tried to download(403): https://mapbox-node-binary.s3.amazonaws.com/sqlite3/v3.1.13/node-v72-win32-x64.tar.gz
SQL
0 vote351 views1 answer
How to add timestamp column in mysql
SQL
0 vote344 views1 answer
Sql select merge multiple values
SQL
0 vote399 views2 answers
What is rownum in oracle
SQL
0 vote341 views1 answer
Postgresql delete multiple rows
SQL
2 votes332 views2 answers
Sqlite_busy: database is locked
SQL
0 vote328 views1 answer
Reading from right to left from string find first special characters in sql
SQL
0 vote338 views1 answer
Google cloud sql postgres url example
SQL