Which of the following SQL statements is correct?
A) FROM Table SELECT Field WHERE Record = 'X' ORDER BY Field
B) WHERE Record = 'X' SELECT Field FROM Table ORDER BY Field
C) SELECT FROM Table Field WHERE Record = 'X' ORDER BY Field
D) ORDER BY Field SELECT Field FROM Table WHERE Record = 'X'
E) None of the above is correct

Question

Quizplus · Accepted Answer

The correct syntax for an SQL query is "SELECT column_name(s) FROM table_name WHERE condition ORDER BY column_name(s);" None of the options provided follow this syntax, making all of them incorrect.

Which of the Following SQL Statements Is Correct