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

JOINs in MS SQL Server

Introduction
Dictionary database
6. Dictionary table – exercise 1
Summary

Instruction

Okay, let's start with our first exercise.

Exercise

Show each dictionary entry (name the column Entry) together with the name of its direct hypernym (name the column Hypernym). Don't show the entires with no hypernym.

Stuck? Here's a hint!

Type:

SELECT
  Entries.Word AS Entry,
  Hypernym.Word AS Hypernym
FROM Dictionary AS Entries
JOIN Dictionary AS Hypernym
  ON Entries.HypernymId = Hypernym.EntryId