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
- 11845 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 clr ddl trigger?
How do indexes help, types?
Suppose i have a table that contains 5 columns like col1,col2...colm5.I want to import only two column through BCP utility.How to do same through BCP in sybase.
What is global temp table?
What is 1nf normalization form?
How do I get to sql server configuration manager?
What is acid properties?
What are the character string functions supported by sql server 2005?
Explain cursor as data base object?
What are types of storage modes? : sql server analysis services, ssas
What is sql server programming?
What are null values in ms sql server?
what is dbcc? : Sql server database administration
Explain raiserror in sql server?
How to drop existing views from a database in ms sql server?
