Summer Deals - hours only!Up to 80% off on all courses and bundles.-Close
Introduction
2. The person table
Syntax of PL/pgSQL
Function parameters
Handling exceptions
Summary

Instruction

Now, let's see what the person table contains.

Exercise

Select all columns from the person table, which stores information about employees who work at the company, as well as a reference to the department each employee works in:

  • person_id
  • department_id
  • first_name
  • last_name
  • start_date
  • gender