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 vote272 views1 answer
Sql database size
SQL
4 votes292 views2 answers
Could not find driver (SQL: SHOW FULL TABLES WHERE table_type = 'BASE TABLE')
SQL
0 vote208 views1 answer
Docker ERROR 2003 (HY000): Can't connect to MySQL server on '127.0.0.1' (61)
SQL
0 vote210 views1 answer
Sql output select
SQL
1 vote176 views1 answer
Database run
SQL
0 vote222 views3 answers
Sql drop all tables
SQL
0 vote226 views1 answer
Postgre query date
SQL
0 vote206 views2 answers
MySQL top percent
SQL
0 vote223 views1 answer
Rollback to name in sql
SQL
1 vote257 views2 answers
Mysql limit offset
SQL