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

Could anyone clearly explain the diference between sub
query and correlated sub query?

Answer Posted / praveen

if we want to select 100th hig no.
in sub-query we will write 100 conditions.
to avoid this we go for correlated sub-query

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is a bind card?

1142


Explain about cursor stability?

982


List out the three types of page locks that can be held.

1091


While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?

2278


What is db2?

1124


Mention the way of highlighting as well as putting a cursor to use in a cobol program.

1018


How do we specify index to include or not during bind process.

2070


What is the difference between bind and rebind in db2?

1393


What is bind package and plan in db2?

1005


What is host variable in db2 cobol?

1028


What is the difference between dbm cfg and db cfg file in db2 ?

1478


What is db2 look?

970


What is scrollable cursor in db2?

996


What is the use of dclgen in db2?

1011


What does db2 plan contain?

960