Do we need cursor for Count(*)?

Answer Posted / shravan kumar.p

no need..
select count(*) from the emp.
it will give the total no of rows in a table..

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to execute stored procedures?

620


Why do chiropractors use drop table?

661


Why cursor is used in db2?

572


What is the clustering index in the db2 database?

582


What are packages in db2?

597






Is the primary key a clustered index?

609


What is consistency token in db2?

640


Can we delete records from view?

566


How to compare data between two tables in db2?

658


While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?

1818


What is a buffer in memory?

600


Explain about cursor stability?

621


What is the difference between nvl and coalesce?

600


What is with ur in db2?

758


How to test SQL -911 error while developing COB-DB2 program

6715