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 INSERT, UPDATE, and DELETE Commands

Introduction
2. The employee table
INSERT with SELECT
Referring to other tables
INSERT, UPDATE, and DELETE with subqueries
Summary

Instruction

We'll start with the employee table, which stores information about the employees who sell products to customers.

Exercise

Select all information from the employee table. This table has the following columns:

  • id – Identifies each employee.
  • first_name – The first name of the employee.
  • last_name – The last name of the employee.
  • salary – The employee's salary.