Do we need cursor for Count(*)?

Answer Posted / sachin borase

select 8 from table fetch first 3 rows only

Is This Answer Correct ?    0 Yes 5 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What do you mean by storage group (stogroup)?

591


Explain about open switch business continuity software?

571


What is db2 catalog database?

589


Why do we use cursor?

602


What are the full forms of spufi and dclgen and why are they used?

662






Give a brief description of db2 isolation levels?

611


How many types of page locks can be held in db2?

597


What does reorg do in db2?

581


What is the role of union all and union

654


What is db2 and what is the use of db2 optimizer?

659


What is the connection string to connect to the DB2 Database ?

618


Is db2 a mainframe database?

573


What are the contents of dclgen?

663


Comment whether the cursor is closed during commit or not.

681


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

737