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 vote117 views1 answer
Transalations from sql to Linq count and group by
SQL
11 votes126 views1 answer
Sql query to find duplicates in column
SQL
0 vote146 views1 answer
Savepoint mysql script
SQL
1 vote119 views1 answer
Sql avg group by
SQL
0 vote120 views1 answer
Postgresql interview questions
SQL
2 votes146 views2 answers
Python escape string for sql
SQL
0 vote124 views1 answer
Mysql workbench format date
SQL
1 vote202 views1 answer
Aqua Data studio postgresql ssl
SQL
2 votes168 views1 answer
How to create sql database
SQL
2 votes124 views1 answer
Get first n letter of department name in sql
SQL