Do we need cursor for Count(*)?

Answer Posted / nak

No,Count(*) will give u the number of record in a table.

Ex: select Count(*) from EMP table where EMPNAME='sunil'

Is This Answer Correct ?    13 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What db2 400?

677


What is host variable in db2 cobol?

604


Mention the various locks that are available in db2.

616


How many databases can be created inside an instance in db2 ?

599


How and when does the db2 enforces the unique key?

615






What is sqlca’s maximum length?

674


What is scrollable cursor in db2?

583


How to compare data between two tables in db2?

658


What is the function of logging in the db2 database?

643


Highlight all the advantages that are attached to a package.

627


How to find the number of rows in a db2 table?

644


what are bind concepts in db2 cobol?

649


What is difference between alias and synonym in db2?

643


What is null indicator in cobol db2?

585


Define predicate?

643