Which of the following is the correct order of keywords for SQL SELECT statements?
A. SELECT, FROM, WHERE
B. FROM, WHERE, SELECT
C. WHERE, FROM,SELECT
D. SELECT,WHERE,FROM
Answer: Option A
Solution (By Examveda Team)
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.
This Question Belongs to Database >> Introduction To SQL
Which of the following is not a DML?
(a) Insert
(b) Update
(c) Delete
(d) Truncate