ASC and DESC direction in MySQL - Cheat Sheet & Quick Revision

Recall & Review

beginner

What does ASC mean in SQL ORDER BY clause?

ASC means ascending order. It sorts data from smallest to largest, like A to Z or 1 to 10.

beginner

What does DESC mean in SQL ORDER BY clause?

DESC means descending order. It sorts data from largest to smallest, like Z to A or 10 to 1.

beginner

How do you sort a list of names in descending order in SQL?

Use ORDER BY column_name DESC. For example: SELECT name FROM users ORDER BY name DESC;

beginner

If you want to sort numbers from smallest to largest, which keyword do you use?

Use ASC to sort numbers from smallest to largest.

beginner

What is the default sorting order if you do not specify ASC or DESC?

The default sorting order is ASC (ascending).

Which keyword sorts data from largest to smallest?

A ASC

B ORDER

C DESC

D SORT

DESC sorts data in descending order, from largest to smallest.

What is the default order when using ORDER BY without ASC or DESC?

A DESC

B ASC

C Random

D No order

The default order is ASC, which means ascending order.

How would you sort a column named 'age' from youngest to oldest?

A ORDER BY age DESC

B ORDER BY age RANDOM

C ORDER BY age

D ORDER BY age ASC

ORDER BY age ASC sorts from smallest (youngest) to largest (oldest).

Which of these is a valid SQL clause to sort data?

A ORDER BY column_name ASC

B SORT BY column_name

C FILTER BY column_name DESC

D GROUP BY column_name ASC

ORDER BY with ASC or DESC is the correct syntax to sort data.

If you want to see the highest scores first, which ORDER BY clause do you use?

A ORDER BY score DESC

B ORDER BY score ASC

C ORDER BY score RANDOM

D ORDER BY score

ORDER BY score DESC shows highest scores first.

Explain the difference between ASC and DESC in SQL sorting.

Think about how you arrange numbers or words from A to Z or Z to A.

How do you write a query to sort a list of products by price from highest to lowest?

Remember DESC means descending order.