What is the order in which the SQL query is executed? list
them in order.
- 5 Answers
- 10096 Views
- CarrizalSoft Technologies, CTS, Oracle, I also Faced
- E-Mail Answers
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 is the order by used for?
what is a transaction? : Sql server database administration
What are ddl triggers and types of ddl trigger?
How to delete a login name in ms sql server?
What will be the value of @@fetch_status if a row that was a part of the cursor resultset has been deleted from the database after the time the stored procedure that opened the cursor was executed?
How to generate create view script on an existing view?
there is a trigger defined for insert operations on a table, in an oltp system. The trigger is written to instantiate a com object and pass the newly inserted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better? : Sql server database administration
What happens if the update subquery returns no rows in ms sql server?
Can we check locks in database? If so, how can we do this lock check?
Is it safe to delete log files?
How to optimize stored procedure optimization?
How to download microsoft sql server 2005 express edition?
Tell me what is the order in which the sql query is executed?
can you implement data mining in SSRS?
how many bits ip address consist of? : Sql server database administration
