Which of the following clause is evaluated in the last by database server?
A. SELECT
B. WHERE
C. FROM
D. None of the mentioned
Answer: Option A
Solution (By Examveda Team)
This question is about the order in which MySQL executes different parts of a SQL query.Imagine you're asking the database for information. You have to tell it where to look (FROM), what conditions to apply (WHERE), and what to bring back (SELECT).
The database server will follow a specific order:
1. FROM: It figures out which tables to use.
2. WHERE: It applies filters to the data based on your conditions.
3. SELECT: Finally, it picks out the specific columns you want from the filtered results.
So the answer is Option D: None of the mentioned. The SELECT clause is evaluated last.

Join The Discussion