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

How do you drop an index?

0 Answers  

How to generate random numbers with the rand() function in ms sql server?

0 Answers  

What you can do to delete a table without the delete trigger firing?

0 Answers  

Can we shrink data file in sql server?

0 Answers  

What do you understand by the denormalisation?

0 Answers  




Does sql server 2000 full-text search support clustering?

0 Answers  

What is BLOCK statements in SQL?

0 Answers   HCL,

What is clustered index

0 Answers  

Will count(column) include columns with null values in its count?

0 Answers  

Explain comment on transactions?

0 Answers  

What is index, cluster index and nonclustered index?

0 Answers  

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?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories