Lesson 4: Sorting Data

Question 1

Sort or Sorting

Answer 1

The process of organizing data in a particular order allowing for information to be found more easily. For example, sorting names in alphabetical order.

Question 2

ORDER BY

Answer 2

SQL clause used to sort the result-set in either ascending or descending order.

Question 3

DESC

Answer 3

SQL keyword used with the ORDER BY clause to indicate descending order. For example, 5, 4, 3, 2, 1 or E, D, C, B, A.

Question 4

ASC

Answer 4

SQL keyword used with the ORDER BY clause to indicate ascending order. For example, 1, 2, 3, 4, 5 or A, B, C, D, E. (default sorting and doesn’t need to be added)

Question 5

Default

Answer 5

The default is a setting that is done automatically. The default can be changed by being specific in the SQL query statement.