HTML 
CSS 
PHP 
JavaScript 
SQL 
Bootstrap 
Solidity 
jQuery 
Git 
Chrome DevTools 
C++ 
Python TL;DR – When a column contains duplicate values and you only need to list the distinct (different) ones, you can use the SELECT DISTINCT command.
Contents
Syntax of SQL SELECT DISTINCT
Example
SELECT DISTINCT column1, column2, ...
FROM table_name;Examples using a demo database
The Developers table
| ID | Name | City | Country |
|---|---|---|---|
| 1 | Tom Kurkutis | New York | USA |
| 2 | Ana Fernandez | London | UK |
| 3 | Antonio Indigo | Paris | France |
| 4 | Aarav Kaelin | Delhi | India |
| 5 | Andrew Tumota | Miami | USA |
| 6 | Basma Zlata | Miami | USA |
Pros Main Features
- Easy to use with a learn-by-doing approach
- Offers quality content
- Gamified in-browser coding experience
- The price matches the quality
- Suitable for learners ranging from beginner to advanced
- Free certificates of completion
- Focused on data science skills
- Flexible learning timetable
Pros Main Features
- Simplistic design (no unnecessary information)
- High-quality courses (even the free ones)
- Variety of features
- Nanodegree programs
- Suitable for enterprises
- Paid Certificates of completion
Pros Main Features
- A wide range of learning programs
- University-level courses
- Easy to navigate
- Verified certificates
- Free learning track available
- University-level courses
- Suitable for enterprises
- Verified certificates of completion
Selecting all values from one column
Selecting only distinct values from one column
Counting distinct values
Note: this example will not work in Microsoft Edge and Firefox, as they use Microsoft Access which doesn't support
COUNT(DISTINCT column_name).
In MS Access
Example
SELECT Count(*) AS DistinctCities
FROM (SELECT DISTINCT City FROM Developers);
