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

Do we need cursor for Count(*)?

Question Posted / nak

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

Please Help Members By Posting Answers For Below Questions

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

1066

Define db2.

1067

Explain how can you do the explain of a dynamic sql statement?

1066

What is the use of dclgen in db2?

1015

What is a plan and package in db2?

1048

How to create backup table in db2?

1044

Explain correlated sub-queries.

979

In case if at some point of time db2 is down, would that impact the pre-compilation process of a db2-cobol program?

993

Mention a credible reason why select* is never given preference in an sql program that has been embedded.

1137

What is the syntax for FETCH in DB2 ?

1141

What does db2 stand for?

961

How can you quickly find out the # of rows updated after an update statement?

987

Mention the length of physical storage of the given data types of db2 – date, timestamp, time

1034

Define check constraint.

1028

What is copy pending status in db2?

1071