What is the correct sequence for a basic SQL retrieval statement using select-from-where?

What is the correct sequence for a basic SQL retrieval statement using select-from-where?

• A. SELECT field(s) FROM table(s) WHERE criteria
• B. FROM table(s) SELECT field(s) WHERE criteria
• C. SELECT field(s) WHERE criteria FROM table(s)
• D. WHERE criteria SELECT field(s) FROM table(s)

Answer: (A)

Data retrieval in SQL must follow a specific order: select specifies the fields to return, from identifies the source table(s), and where applies filters to limit the rows. This sequence is the valid way to construct a basic retrieval statement and matches how the query engine parses the statement. The where clause, when used, must come after the from clause because you first define what data source you’re querying from, then apply conditions to that data. The other arrangements place parts of the statement in an order SQL doesn’t accept, such as listing the table before the fields or placing the filter before the data source has been defined.

Data retrieval in SQL must follow a specific order: select specifies the fields to return, from identifies the source table(s), and where applies filters to limit the rows. This sequence is the valid way to construct a basic retrieval statement and matches how the query engine parses the statement. The where clause, when used, must come after the from clause because you first define what data source you’re querying from, then apply conditions to that data. The other arrangements place parts of the statement in an order SQL doesn’t accept, such as listing the table before the fields or placing the filter before the data source has been defined.