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

Why db2 is called db2?

596


Define db2 and its databases?

622


What is explain plan in db2?

592


What is the syntax for creating a table in the db2 database?

628


Explain various types of locks in db2?

693






What is load replace in db2?

562


Can you use max on a char column?

640


What are union and union all?

541


How to check sequence on a table in db2?

602


What do you mean by cursor?

586


Is db2 a mainframe database?

569


What db2 400?

680


Which command is used to remove all rows from a table?

553


What is a db2 package?

601


Which component is responsible for processing sql statements and selecting access paths?

671