PostgreSQL MIN and MAX

PostgreSQL Notes · Coding Now Tech Institute1 min readSource

MIN

The MIN() function returns the smallest value of the selected column.

Example

SELECT MIN(price)
FROM products;

MAX

The MAX() function returns the largest value of the selected column.

Example

SELECT MAX(price)
FROM products;

Set Column Name

When you use MIN() or MAX(), the returned column will be named min or max by default. To give the column a new name, use the AS keyword.

Example

SELECT MIN(price) AS lowest_price
FROM products;

PreviousPostgreSQL LIMIT Next PostgreSQL COUNT

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 MIN and MAX – FAQs

Quick answers about learning PostgreSQL MIN and MAX in PostgreSQL.

What does this PostgreSQL MIN and MAX note cover?

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

Is this PostgreSQL MIN and MAX tutorial free?

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

How long does it take to learn PostgreSQL MIN and MAX?

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