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. Ingredient table
Quiz
Congratulations

Instruction

Another table is the ingredient table. This table contains details about each ingredient, i.e. its name and type.

Exercise

Select all columns from the table ingredient. This table includes:

  • id – An identifier for the ingredient.
  • name – The name of the ingredient.
  • type – The ingredient type, such as fruit, vegetable, etc.