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

PostgreSQL JOINs

Introduction
Dictionary database
5. Get to know the dictionary table
Summary

Instruction

Okay, let's try another table, shall we?

In the next couple of exercises, we'll work with words in a dictionary. Do you know that linguists classify words?

Our table contains some English words and their hypernyms.

A hypernym is a term with a broad meaning, that "contains" other terms. For example, the hypernym of "sparrow" is "bird".

Exercise

Select all data from the dictionary table. It contains the following columns:

  • entry_id - the ID of an entry in the dictionary,
  • word - the word associated with a particular entry,
  • hypernym_id - the ID of an entry that is a hypernym for a particular word.

Stuck? Here's a hint!

Type: 

SELECT *
FROM dictionary