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 db2 restart?

2212


Give the name of some fields form sqlca.

1142


What is the latest version of ibm db2?

1331


What is meant by dclgen?

1168


Are views updateable?

1230


What is null indicator in db2?

1160


Define sqlca.

1164


How to rename a table in DB2 ?

1141


Which are the db2 tools to protect integrity of the database?

1163


How can deadlocks be resolved?

986


Can there be more than one cursor open for any program?

1223


What is the use of dclgen in db2?

1135


If I have a view which is a join of two or more tables, can this view be updateable?

1184


File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?

3002


What is the maximum No of rows per page?

1107