Question

Among the below Order By queries, which are correct ones?

A) SELECT * FROM Table Order By Column;
B) SELECT * FROM Table Order By Column ASC;
C) SELECT * FROM Table Order By Column DESC;
D) All of the above
E) None of the above

Answer 1

The correct Order By queries are Options A and C, and Option B is also correct but not listed separately as it is the default behavior.

Step-by-step explanation:

The correct Order By queries among the given options are:

1. A) SELECT * FROM Table Order By Column;
2. C) SELECT * FROM Table Order By Column DESC;

Option B) SELECT * FROM Table Order By Column ASC; is also correct, but it is not listed separately as it is the default behavior of the ORDER BY clause. Therefore, the correct answer is Option D) All of the above.