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

Nice! SQL makes it also extremely easy to sort rows. Take a look:

SELECT *
FROM employee
ORDER BY department;

In the query above, we select all the information from the employee table and sort the rows by the department using a ORDER BY clause. In SQL, rows are sorted in the ascending order by default.

Exercise

The German couple found a nice hotel thanks to our help. Now, they are beginning to think about another trip... let's help them pick something nice!

Show the name and city of all hotels. Sort the rows by the city name.

Stuck? Here's a hint!

Type:

SELECT name, city
FROM hotel
ORDER BY city;