PostgreSQL COUNT

PostgreSQL Notes · Coding Now Tech Institute1 min readSource

COUNT

The COUNT() function returns the number of rows that matches a specified criterion.

If the specified criterion is a column name, the COUNT() function returns the number of rows with that name.

Example

SELECT COUNT(customer_id)
FROM customers;

Note: NULL values are not counted.

By specifying a WHERE clause, you can e.g. return the number of customers that comes from London:

Example

SELECT COUNT(customer_id)
FROM customers
WHERE city = 'London';

PreviousPostgreSQL MIN and MAX Next PostgreSQL SUM

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 COUNT – FAQs

Quick answers about learning PostgreSQL COUNT in PostgreSQL.

What does this PostgreSQL COUNT note cover?

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

Is this PostgreSQL COUNT tutorial free?

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

How long does it take to learn PostgreSQL COUNT?

With focused practice, most students grasp PostgreSQL COUNT 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 COUNT 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.