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
- 11773 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
Define clusters?
What is truncate table?
What does set rowcount do?
How to optimize stored procedure optimization?
What are the basic functions for master, msdb, model, tempdb databases?
What are relationships and mention different types of relationships in the dbms
List layers of abstraction microsoft architectured to provide relational db through cloud platform ?
What is use of attribute hierarchy ordered ? : sql server analysis services, ssas
Define left outer join in sql server joins?
Do you know how to store and query spatial data?
What are the types of dml?
Data table as parameter in sql server?
Difference between Sql server reporting services and Crystal reports?
If we delete pack Spec what will be the status of pack Body ?
What is the default server name for sql server?
