What is the disadvantage of using subquery exact after a
select statement?ex.
select (select * from sometable)
- 1 Answers
- 11504 Views
- I also Faced
- E-Mail Answers
Answer Posted / sandeep
Main difference is the outer and inner querries are
independent each other. This executes inner querry for each
and every rows in outer querry. It is better to use joins
instead of sub querries where it is possible. But in some
cases we cud use subquerries
| Is This Answer Correct ? | 12 Yes | 0 No |
Post New Answer View All Answers
In one interview...interviewer ask me question pleas tell me sql server architecture.. can any body tell me the sql server architecture with digram
How do clustered indexes store data?
When should you use an instead of trigger?
How many types of functions are there in sql server?
What security features are available for stored procedure?
Does sql server 2000 full-text search support clustering?
What is pivot and unpivot?
Would you store your query in a ssrs report or a database server? State the reason why?
What are the differences between union, intersect, and minus operators?
What are the new features of sql server 2008 r2 reporting service?
Do you know what are acid properties of transaction?
What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting are possible?
Explain stored procedure?
When multiple after triggers are attached to sql table, how to control the order of execution?
What are the types of containers in ssis?
