Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close

Wrap course as a gift

Prepare your gift and double-check it looks just right.

Form validation errors

Recipient's Name:
Recipient's Email:
Your Message (Optional):
Proceed to Checkout

Common Functions in PostgreSQL

Introduction
The COALESCE() function
The GREATEST() & LEAST() functions
10. The LEAST() function
The NULLIF() function
Summary

Instruction

Similar to the GREATEST() function there is the LEAST() function. Here is the query using it:

SELECT
  id,
  LEAST(market1_price, market2_price) AS smallest_price
FROM product;

This query returns the lowest price between shop 1 and shop 2.

Exercise

Find the smallest price of each product among prices in all three shops. Select ID, the name of the product, and the smallest price as the smallest_price column.

Stuck? Here's a hint!

Use this expression:

LEAST(market1_price, market2_price, market3_price) AS smallest_price