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

Window Functions in PostgreSQL

When window functions are evaluated
Summary
19. Table book

Instruction

In order to test your knowledge, we'll use a very simple table called book. Let's check its contents.

Exercise

Select all columns from the book table.

Each book has its own id, the id of its author, publication year in the publish_year column, a certain price and a rating from 0 to 10.