What is the order in which the SQL query is executed? list
them in order.
Answer Posted / 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 |
Post New Answer View All Answers
What does sql server mean?
What method is used by the Command classes to execute SQL statements that return single values?
What do you understand by check constraint in sql server?
How do use Having,Group by,Group function in SQL?
Explain alternate key, candidate key and composite key in sql server?
how to control the amount of free space in your index pages? : Sql server database administration
What is sub-query in sql server?
How to configure and test odbc dsn settings?
What are the High-Availability solutions in SQL Server and differentiate them briefly?
What are the main sources of data?
What is the difference between functions and stored procedures?
What are the types of user defined functions in sql server?
Does partitioning help performance?
can a table be moved to different filegroup? : Sql server administration
What is save transaction and save point?