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 does reorg do in db2?

983


What is db2?

1123


Explain about mirror activator disk mirroring?

952


What is the difference between oracle and db2?

1028


What are union and union all?

920


How to create backup table in db2?

1041


What is the use of db2 optimizer?

1029


How do you eliminate duplicate values in db2?

1107


What is the physical storage length of timestamp data type?

1022


Explain dclgen.

1141


How to create db2 table in mainframe?

1096


What are db2 objects?

999


What is db2 stogroup?

1093


What is the difference between plan and package in db2?

1034


How to rename a table in DB2 ?

1023