What is the order in which the SQL query is executed? list
them in order.
- 5 Answers
- 10854 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
Can you explain the disadvantages/limitation of the cursor?
Which is better statement or preparedstatement?
How retrieve field names from the table in SQL through JAVA code?
How to recompile stored procedure at run time?
What is 'Join' and explain its various types.
Do you know data definition language, data control language and data manipulation language?
What is NOT NULL Constraint in sql server 2012?
What are the disadvantages of primary key and foreign key in SQL?
What is the difference between composite index and covering index?
How to add a new column to an existing table with "alter table ... Add" in ms sql server?
What are the database objects? : SQL Server Architecture
How to access the deleted record of an event?
How to insert multiple rows with a subquery?
Give some Scenario for Non Clusterd index? Can we write system defined functions in side The Function? Wat is the Unique Datatype?
Define msdb database?
