End of Summer - hours only!Up to 80% off on all courses and bundles.-Close
SQL Basics
Summary

Instruction

Good! So far, we only had control over what columns were shown. Now, we'd like to specify which rows should be selected too. Take a look:

SELECT *
FROM employee
WHERE department = 'Accounting';

In the query above, a new clause appeared: WHERE. It is used to filter rows. In this case, we only want to see rows where the department columns contains the text "Accounting". Employees from any other departments won't be shown at all. Note that we used the equality sign (=) and that 'Accounting' must be surrounded with single quotes.

Exercise

We've got a German couple who would like to go and see the Eiffel tower. But they need to sleep somewhere!

Select all the information from the hotel table for hotels in Paris.

Stuck? Here's a hint!

Type:

SELECT *
FROM hotel
WHERE city = 'Paris';