PostgreSQL SELECT DISTINCT

PostgreSQL Notes · CodingNow 2.01 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 CodingNow 2.0'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 CodingNow 2.0 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 CodingNow 2.0, 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 CodingNow 2.0'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 CodingNow 2.0 Community (/community) — expert instructors answer within 24 hours.