Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  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 is exclusive locks?

0 Answers  

What is the difference between indexing and hashing?

0 Answers  

What are translations and its use? : sql server analysis services, ssas

0 Answers  

What is the difference between a check constraint and a rule?

0 Answers  

What are the different SQL Server Versions you have worked on?

0 Answers  

What are the advantages of using sql server over ms access or why should one use sql instead of ms access

2 Answers   CMS, Impetus,

What do you mean by a Composite primary key?

0 Answers   Genpact,

How to concatenate two strings in SQL Server.

0 Answers   HCL,

Explain Normalization and DE normalization

0 Answers   iNautix,

What are the basic functions for master, msdb, model, tempdb and resource databases? : SQL Server Architecture

0 Answers  

how many joins we can write if at all we have n no of tables

5 Answers   Tanla Solutions, TS,

What is the distinction amongst delete and truncate?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories