Which database operation is used to arrange records in ascending or descending order?

Options

  • A. GROUP BY
  • B. ORDER BY
  • C. WHERE
  • D. More than one of the above
  • E. None of the above

Correct Answer (Detailed Explanation is Below)

B. ORDER BY

Detailed Explanation

  • ORDER BY: Sorts query results in ascending or descending order.
  • ASC: Specifies ascending order and is the default sorting order.
  • DESC: Specifies descending order.