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...

diff b/w sub query and co-relater query?

Answer Posted / ganesh

sub query is select statement which is lying in clause of
another sql stament


corelated subquery:

it is row-by-row processing, in which outer sub query is
processing for every inner query result

Is This Answer Correct ?    5 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Is it possible to remove child records without removing master table records...the two having pk,fk relationship?

1264


what is denormalization. : Sql dba

1104


What is difference between hql and sql?

1070


what are the advantages of sql ? : Sql dba

1054


What is a variable in sql?

997


What is trigger and how to use it in sql?

1021


What is Histogram?

1554


What are the different ways to optimize a sql query?

944


What is difference between db2 and sql?

997


What is sql architecture?

1045


How to fetch values from testtable1 that are not in testtable2 without using not keyword?

1214


hi,i plan to put experience on PLSQL ,can anyone suggest me for any institutes in bangalore or how to prepare for interviews

2012


How is sql used in oracle?

1001


What is not null in sql?

1053


Explain the steps needed to create the scheduled job?

1036