Machine-translated by Google. Questions are authored in English.
Top

Discussion

The clause in SQL that specifies that the query result should be sorted in ascending or descending order based on the values of one or more columns is

  • A.View
  • B.Order by
  • C.Group by
  • D.Having

Answer: B

Correct answer: Order by

ORDER BY sorts the result, taking ASC or DESC and one or more columns. GROUP BY collects rows into groups and HAVING filters those groups; neither of them sorts.

No comment is present. Be the first to comment.
Loading…

Post your comment

Please log in or register to post a comment.