PostgreSQL SELECT DISTINCT

PostgreSQL Notes · Coding Now Tech Institute1 min readSource

The SELECT DISTINCT Statement

The SELECT DISTINCT statement is used to return only distinct (different) values.

Inside a table, a column often contains many duplicate values and sometimes you only want to list the different (distinct) values.

Example

SELECT DISTINCT country FROM customers;

Even though the customers table has 91 records, it only has 21 different countries, and that is what you get as a result when executing the SELECT DISTINCT statement above

SELECT COUNT(DISTINCT)

We can also use the DISTINCT keyword in combination with the COUNT statement, which in the example below will return the number of different countries there are in the customers table.

Example

SELECT COUNT(DISTINCT country) FROM customers;

PreviousPostgreSQL SELECT Next PostgreSQL WHERE

Want to go beyond the notes?

Join Coding Now Tech Institute's PostgreSQL course — live mentorship, real projects, and 100% placement support.

Enroll Now — Free Demo Available

PostgreSQL SELECT DISTINCT – FAQs

Quick answers about learning PostgreSQL SELECT DISTINCT in PostgreSQL.

What does this PostgreSQL SELECT DISTINCT note cover?

This free note from Coding Now Tech Institute explains PostgreSQL SELECT DISTINCT in PostgreSQL — concept, syntax and worked code examples you can copy, run and revise before interviews.

Is this PostgreSQL SELECT DISTINCT tutorial free?

Yes. Every PostgreSQL topic on Coding Now Tech Institute, including PostgreSQL SELECT DISTINCT, is 100% free with no signup required.

How long does it take to learn PostgreSQL SELECT DISTINCT?

With focused practice, most students grasp PostgreSQL SELECT DISTINCT in 1–3 days from these notes; pairing it with Coding Now Tech Institute's mentor-led course takes you to job-ready depth faster.

Where can I practise PostgreSQL SELECT DISTINCT after reading?

Use the code examples in this note, then ask doubts for free on the Coding Now Tech Institute Community (/community) — expert instructors answer within 24 hours.