What is the order in which the SQL query is executed? list
them in order.
Answers were Sorted based on User's Feedback
Answer / ela tiku
At runtime the compiler first takes the table name from
where the data is to be retrieved (FROM <tablename>), then
it checks for the condition (Where <condition>) then it
selects the values to me displayed as o/p
|Is This Answer Correct ?||6 Yes||1 No|
Answer / nandkumar karlekar
The order of Execution is as follows
1.From clause and joins
2.independent subqueries in the where clause
3.where clause last condition execute first but if the
index is present then these condiyions execute first
|Is This Answer Correct ?||3 Yes||0 No|
Answer / l. meher
When a SQL query is getting executed it goes through the
1) It goes to the shared pool which contains information
such as the parse tree and execution plan for the
2)Validate the SQL statement.
3)Validate the source.
5)Checks for previllages.
6)Parse the statement.
7)Execute the Query.
8)Fetch the value (only for select statement).
9)Generate the redo information.
If you have any doubt mail me at email@example.com
|Is This Answer Correct ?||5 Yes||4 No|
Answer / selvam
|Is This Answer Correct ?||1 Yes||0 No|
Answer / suraj
Though it's not so clear on what type of SQL query.
If we want to see in what order does the SELECT query
executes; it'l like this.
GROUP BY ...........
|Is This Answer Correct ?||6 Yes||6 No|
Explain how many normalization forms?
How to receive returning result from a query?
what's new in sql server 2016?
how to control the amount of free space in your index pages? : Sql server database administration
What will happen when a Rollback statement is executed inside a trigger?
Describe in brief databases and sql server databases architecture.
What are all new concepts in SQL Server 2008? That is Exactly Difference between 2005 to 2008
Which tcl commands are available on the sql server?
What are the types of model in sql server and explain
Explain nested trigger in sql?
Find 2nd Highest salery in emp table Select* from emp where &n= select * count from emp where (salery >=emp.salery) Enter n value 2 These query is correct or not. Tell me any other methods.
SQL Server Architecture ?