1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

What is the disadvantage of using subquery exact after a
select statement?ex.
select (select * from sometable)

Question Posted / compmastbipin@yahoo.com


What is the disadvantage of using subquery exact after a select statement?ex. select (select * fr..

Answer / 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

More SQL Server Interview Questions

tell me what is blocking and how would you troubleshoot it? : Sql server database administration

0 Answers  

What is the difference between UNIQUE and DISTINCT keywords in DBMS?

1 Answers   Genpact,

Tell me what is difference between clustered and non clustered index?

0 Answers  

What is the difference between IN and EXISTS operators in SQL Server?

9 Answers   ASD Lab, CSC, Intelligroup,

How to transfer an existing table from one schema to another schema in ms sql server?

0 Answers  




how will add additional conditions in sql?

0 Answers   Amdocs, Apps Associates,

Explain about integration services of Microsoft SQL server?

0 Answers  

can we call stored Procedure in Function in Sql Server 2000 and vice versa.

3 Answers   C3I, eSoft, iPRO Solutions, Wipro,

what is hash table

3 Answers   ILFS, Teledata,

How do I determine how many instances of sql server are installed on a computer?

0 Answers  

What is the datatype of rowid?

0 Answers  

Is it possible in sql table to have more than one foreign key?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories