Question

Kritika did not use ASC or DESC keyword with ORDER BY clause. By default in which order will the result of the query be displayed?

Hint:

In SQL, ORDER BY sorts results in ascending order unless stated otherwise.

Answer 1

In SQL, the ORDER BY clause is used to sort the result set of a query based on one or more columns.
The sorting can be done either in ascending (ASC) or descending (DESC) order.
However, if neither ASC nor DESC is explicitly mentioned, the default sorting order is ascending.
This means that values will be arranged from smallest to largest — for numbers, lowest to highest; for text, alphabetically A to Z.
Therefore, even if Kritika omits ASC or DESC, the data will still be sorted in ascending order by default.