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 MS SQL Server

Introduction
3. The Ingredient table
Quiz
Congratulations

Instruction

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

Exercise

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

  • Id – the identifier of the ingredient,
  • Name – the name of the ingredient,
  • Type – the type of the ingredient, such as fruit, vegetable, etc.