ORDER BY single column in MySQL - Cheat Sheet & Quick Revision

Recall & Review

beginner

What does the ORDER BY clause do in a SQL query?

It sorts the rows returned by the query based on one or more columns, either in ascending or descending order.

beginner

How do you sort query results by a single column in ascending order?

Use ORDER BY column_name ASC. ASC means ascending order and is the default if not specified.

beginner

How do you sort query results by a single column in descending order?

Use ORDER BY column_name DESC. DESC means descending order.

beginner

What happens if you use ORDER BY without specifying ASC or DESC?

The results are sorted in ascending order by default.

beginner

Write a simple SQL query to select all columns from a table named employees and order the results by the last_name column.

SELECT * FROM employees ORDER BY last_name;

What does ORDER BY salary DESC do?

A Sorts salaries from highest to lowest

B Sorts salaries from lowest to highest

C Filters salaries greater than DESC

D Groups salaries by DESC

DESC means descending order, so salaries are sorted from highest to lowest.

Which keyword sorts data in ascending order?

A SORT

B DESC

C ASC

D ORDER

ASC sorts data in ascending order. It is also the default if no keyword is specified.

What is the default sort order if you write ORDER BY age without ASC or DESC?

A Descending

B Ascending

C No sorting

D Random

By default, ORDER BY sorts in ascending order.

Which SQL clause is used to sort query results?

A HAVING

B GROUP BY

C WHERE

D ORDER BY

ORDER BY sorts the results of a query.

How would you sort a table named products by the price column in ascending order?

A SELECT * FROM products ORDER BY price ASC;

B SELECT * FROM products SORT BY price;

C SELECT * FROM products ORDER BY price DESC;

D SELECT * FROM products GROUP BY price;

Use ORDER BY price ASC to sort prices from lowest to highest.

Explain how to use the ORDER BY clause to sort data by a single column in SQL.

Think about how you tell SQL to arrange rows by one column.

Write an example SQL query that selects all data from a table and sorts it by a column named date_created in descending order.

Use ORDER BY with DESC to sort newest first.