Which of the following Oracle SQL statements is not correct?
2018
Which of the following Oracle SQL statements is not correct?
- A.
SELECT * FROM Customers
ORDER BY Country; - B.
SELECT * FROM Customers
ORDER BY Country DESC; - C.
SELECT * FROM Customers
ORDER BY Country ASC, DESC CustomerName; - D.
SELECT * FROM Customers
ORDER BY Country ASC, CustomerName DESC;
Attempted by 257 students.
Show answer & explanation
Correct answer: C
Option C is incorrect because Oracle SQL requires column names to precede ASC or DESC keywords in the ORDER BY clause. In option C, the keyword DESC appears before the column identifier CustomerName without a preceding column name.