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

Do we need cursor for Count(*)?

Question Posted / nak

4 Answers
8910 Views
iGate, I also Faced
E-Mail Answers

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 is cursor in dbms?

1023

What is innodb buffer pool?

1005

What is query_cache_limit?

941

What is the role of union all and union

1093

What is cursor with hold option in db2?

1033

What is dbrm?

1062

What is ibm db2 database?

969

File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?

2884

What is syscat in db2?

966

What is db2 command?

988

How will you return the number of records in table?

896

in my project..TEST is db2 8.1 version In PROD it is 7.1 if i do REORG in TEST.. can I use the same REORG jcl with out modification in PROD region (this is DB2 8.1 )? if not, what modification i need to do in my REORG control card?

2042

What is dclgen in db2?

1095

What is meant by explain?

1083

Describe major components of db2?

1065