Code has been added to clipboard!

Using SQL ORDER BY and SORT BY

Reading time 2 min
Published Aug 9, 2017
Updated Oct 11, 2019

SQL ORDER BY Keyword: Main Tips

  • The keyword ORDER BY is used for sorting the result-set that is created using the SELECT statement.
  • Using this statement you can sort the result-set by one or multiple columns in an ascending or descending order.
  • ORDER BY sorts in an ascending order by default.

Syntax of SQL ORDER BY Keyword

Example
SELECT * FROM users ORDER BY email ASC, username DESC;
Udacity
Pros
  • Simplistic design (no unnecessary information)
  • High-quality courses (even the free ones)
  • Variety of features
Main Features
  • Nanodegree programs
  • Suitable for enterprises
  • Paid certificates of completion
Coursera
Pros
  • Professional service
  • Flexible timetables
  • A variety of features to choose from
Main Features
  • Professional certificates of completion
  • University-level courses
  • Multiple Online degree programs
Datacamp
Pros
  • Great user experience
  • Offers quality content
  • Very transparent with their pricing
Main Features
  • Free certificates of completion
  • Focused on data science skills
  • Flexible learning timetable

Demo Database

In this example, we are using a basic SQL database.

Right here we have a section from the table called "Users":

ID Username Email Password
1 alfredfutter [email protected] secret1
2 atrujillo [email protected] secret2
3 moreno.antonio [email protected] secret3
4 hardythomas [email protected] secret4
5 bergluns [email protected] secret5

The following SQL statement selects all users from the "users" table, sorted by the "email" column:

Example
SELECT * FROM users ORDER BY email;

SQL ORDER BY Keyword ORDER BY DESC

This statement will select every user from the table called "users", and sort them in a descending order by the "email" column:

Example
SELECT * FROM users ORDER BY email DESC;

SQL ORDER BY Keyword ORDER BY Several Columns

This statement will select every user from the table called "users", and sort them in an ascending order by the "email" and the "username" columns:

Example
SELECT * FROM users ORDER BY email, username;

This statement will select every user from the table called "users", and sort them in a descending order by the "email" and the "username" columns:

Example
SELECT * FROM users ORDER BY email ASC, username DESC;

Latest Udacity Coupon Found:

Verified STAFF PICK

75% OFF COURSES

Udacity Black Friday Offer

The best time to save on Udacity courses is now - follow this coupon to access a 75% Udacity Black Friday discount & enjoy learning at a very low cost!

Expiration date: 19/01/2021
3176 People Used
Only 97 Left
Rating
5.0