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

Do we need cursor for Count(*)?

Answer Posted / yaswanth

we will use cursors when we have situation like the query
returning multiple rows but in this case
select Count(*) from EMP table where EMPNAME='some' will
return only one row, i.e how many rows it found with
EMPNAME='some' eg:3 or 4 or 5 ... so there is no concept of
cursor here

Is This Answer Correct ?    9 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the picture clause of null indicator variable?

1139


What is a plan and package in db2?

1108


What is explain plan in db2?

1006


How to retrieve rows from a db2 table in embedded sql?

1398


What is data manager?

1056


What language is db2 written in?

1052


What is db2 purescale?

1012


What is a db2 collection?

1054


How to restart a DB2 program?

1911


What is dclgen in db2?

1154


What are the uses of db2 optimizer?

1299


What is copy pending status in db2?

1128


What is declare cursor?

1127


What is load replace in db2?

1004


Which command is used to connect to a database in DB2 ? Give the Syntax.

1107