Interested to Buy Any Domain ? << Click Here >> for more details...
What is the disadvantage of using subquery exact after a
select statement?ex.
select (select * from sometable)
- 1 Answers
- 11877 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
Do you know exporting and importing utility?
Do you know what is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting is possible?
what are the reporting service components in SSRS?
Why do we need normalization?
What do you understand by a stored procedure?
What are some examples of schemas?
What is mapping schema?
Define magic tables in sql server?
What are the grouping functions?
How do you set a trace flag in sql server?
What is precedence constraint?
What is the default server name for sql server?
What factors you will consider calculating the storage requirement for that view?
What do you understand by replication in sql server?
How to create a simple stored procedure in ms sql server?
