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 phantom read in db2?

1157


What is ibm db2 client?

939


How to find primary key of a table in db2?

1065


What is cascading rollback?

1214


How to resolve deadlock issue

20122


What is access path in db2?

986


What is an instance database?

1052


What are the bind parameters ibm db2?

1053


How to connect to db2 database from windows command line?

1065


What happens in bind step in a db2 program?

971


What is a db2 collection?

1040


What is load replace in db2?

992


What does db2 plan contain?

1019


Can you tell me how can you find out the # of rows updated after an update statement?

1101


How is deadlock resolved?

1146