Q12
Which of the following is the correct order of keywords for SQL SELECT statements?
A.
SELECT, FROM, WHERE
AnswerB.
FROM, WHERE, SELECT
C.
WHERE, FROM,SELECT
D.
SELECT,WHERE,FROM
Answer: Option A
Solution
Answer: Option A
Solution:
Option A: SELECT, FROM, WHERE - This option presents the correct order of keywords for a SQL SELECT statement:SELECT: Specifies the columns to retrieve data from.
FROM: Specifies the table from which to retrieve data.
WHERE: Optional clause that specifies conditions to filter rows.
Option B: FROM, WHERE, SELECT - Incorrect order. The SELECT keyword should come before FROM to specify the columns to select. Option C: WHERE, FROM, SELECT - Incorrect order. The SELECT keyword should come before FROM to specify the columns to select. Option D: SELECT,WHERE,FROM - Incorrect order. The FROM keyword should come after SELECT to specify the table from which to select data. Conclusion:
The correct order of keywords for a SQL SELECT statement is Option A: SELECT, FROM, WHERE.