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

Recursive Queries in PostgreSQL

Introduction
3. Product table
Using CTEs with data-modifying statements
Summary

Instruction

OK. Now the second table, product. It contains details about the items sold in the grocery stores.

Exercise

Select all information from the product table. This table consists of these columns:

  • id – An identifier for each product/grocery store combination.
  • name – The name of the product.
  • price – The price of the product.
  • grocery_store_id – The ID of the grocery store where the product is stocked.