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 / suresh somayajula

Sub Query : In this Inner query will execute first. Based
on that result outer query will execute.

Correlated Sub Query : Query which has reference to the
main query , means outer query will execute first based o
that result inner query will execute.

Thank you,
Suresh.

Is This Answer Correct ?    6 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

how to rename an existing column in a table? : Sql dba

1016


What is difference between pls_integer and integer?

950


what are the advantages of sql ? : Sql dba

1057


what is bcp? When is it used?

1106


How do you drop a trigger?

985


How can we debug in PL/SQL?

1131


What are types of indexes in sql?

1078


What is the difference between left and left outer join?

944


What does the hierarchical profiler does?

1057


How do you declare a user-defined exception?

1022


Explain what is table in a database?

1055


What is scalar data type in pl sql?

1066


What is the difference between subquery and correlated query?

1063


How do I delete a trigger?

962


What is mutating error?

964