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
- 12004 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 default server name for sql server?
Explain about Normalization?
Can a trigger be created on a view?
How to stop a loop early with break statements in ms sql server?
what are different types of backups available in sql server? : Sql server database administration
Differentiate between SQL and ORACLE joins and write their syntax.
What is the purpose of the model database?
How to create a user to access a database in ms sql server using "create user" statements?
Give me any three differences between Truncate and Delete.
Can sql servers link to other servers?
Is sql server is free?
Tell me can we use custom code in ssrs?
Explain tablesample?
What is shared lock?
Write a Select Query to display title for each group of records, which are collected with Compute Clause? Like titlefield column-A column-B ..... ..... ..... Sum ... titlefield column-A column-B ..... ..... ..... Sum ...
