Multiple choice technology databases

Can the ORDER BY clause use column index of the select clause to sort the fetched records.

  1. True

  2. False
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

The ORDER BY clause allows sorting by the column's position (index) in the SELECT list. For example, 'ORDER BY 2' sorts by the second column selected. While this practice is often discouraged in production code for readability, it is syntactically valid.

Keep practicing — related questions