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

Creating Tables in SQL

Introduction
Text information
Boolean
Date and time
Summary

Instruction

That's right. We've already mentioned that one of the reasons for data types is that we can sort information if we know what they are. Let's check that.

SELECT * FROM user_account
ORDER BY nickname;

As you can see, we can sort the results of our SELECT statement by writing ORDER BY followed by the name of the column (or a few columns separated with commas). The default order is ascending (that is, A comes before B). If you want to reverse the order, just put DESC after the name of the column:

SELECT *
FROM user_account
ORDER BY nickname DESC;

Exercise

Peter started working on his database and he he now has an impressive number of two columns in his table user_account: columns first_name and nickname.

Let's retrieve all information from the table and sort it according to the values in column first_name in the ascending order.

Stuck? Here's a hint!

Type

SELECT *
FROM user_account
ORDER BY first_name;