Sign Up Login


  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

what kind of lan types do you know? : Sql server database administration

0 Answers  

What is default port number for sql server 2000?

0 Answers  

what is for foreign key ??

4 Answers   CarrizalSoft Technologies, Sabic,

How many clustered indexes there can be on table ?

0 Answers  

What does truncate do?

0 Answers  




Can you move the resources after pausing the node? : sql server database administration

0 Answers  

What do you mean by authentication modes in sql server?

0 Answers  

What is an Index?

3 Answers   Yardi Software,

How to perform key word search in tables?

0 Answers  

‘Order by’ is not allowed in a view how can you sort information from a view?

0 Answers  

What are different types of statements that are supported by sql?

0 Answers  

How to provide Security for package?

1 Answers   Convergys,

For more SQL Server Interview Questions Click Here
Categories