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

What is the purpose of coding FETCH in a SQL SELECT query?
Explain with an example in Detail?

Answer Posted / guest

FETCH is used to retrieve a specific row from a result set
of the SELECT query and places them into local variables.

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to access db2 tables in mainframe?

1051


What is dbrm? What it contains? When it will be created?

1045


How will you return the number of records in table?

932


What is consistency token in db2?

1134


before altering a table is it necessary to lock ? if lock what is it ? how to do ? ifi want to lock a table what is that command ?

2176


Which component is used to execute the sql statements?

1094


What are union and union all?

976


What do you mean by commit and rollback?

1032


Discuss about db2 bind?

1088


How would you find out the total number of rows in a db2 table?

1048


What is the use of dclgen in db2?

1079


What is a db2 table?

1005


What is the maximum No of rows per page?

1063


What is universal database?

1066


Define sqlca.

1103