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

Learn SQL Webinar

SQL Basics
Summary

Instruction

Great! Now, instead of all the information, we'd like to only show selected columns. How do we do that? Take a look:

SELECT full_name, department
FROM employee;

The query above only shows columns full_name and department for all rows from the employee table. The other columns (id, level, is_full_time) won't be shown.

Exercise

Now, select the name and city columns from the hotel table.

Stuck? Here's a hint!

Type:

SELECT name, city
FROM hotel;