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
- 11983 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
What is the use of “join” in sql server?
what are the Prerequisites for Replication?
What is difference between views and tables?
How to include text values in sql statements?
Mention a few common trace flags used with sql server?
What are drilldown reports?
What is cte (common table expression)?
How to select all columns of all rows from a table with a select statement in ms sql server?
What is an inner join?
Define model database?
what is the difference between them (ethernet networks and token ring networks)? : Sql server database administration
what is a default tcp/ip socket assigned for sql server? : Sql server database administration
Explain different types of Normalization.
What are subquery and its properties?
How to change the system date and time from SQL Plus Terminal ?
