Interested to Buy Any Domain ? << Click Here >> for more details...
What is the order in which the SQL query is executed? list
them in order.
- 5 Answers
- 11589 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 data source view or dsv? : sql server analysis services, ssas
You want to generate a report that is formatted as a chart. Can you use the report wizard to create such a report?
What are the advantages of passing name-value pairs as parameters?
How to create sub reports?
Which tcp/ip port does the sql server run on? How can it be changed?
Can group by and orderby be used together?
What is the use of group by clause?
Tell me what is difference between clustered and non clustered index?
How to run queries with sql server management studio express?
What is Lock table in SQL?
How real and float literal values are rounded?
How to modify the underlying query of an existing view?
What is an index in sql?
Explain the etl (extraction, transformation, and loading)?
What do you understand by check constraint in sql server?
