Question

If we have not specified ASC or DESC after a SQL ORDER BY clause, the following is used by default

Select the correct answer from below options:

a) DESC

b) ASC

c) There is no default value

d) None of the mentioned

Answer 1

If we have not specified any sorting with the ORDER BY clause, SQL always uses the ASC as a default sorting order. SQL treats Null as the lowest possible values while sorting.

b) ASC