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

What is the difference between spufi and qmf?

1103

What is meant by explain?

1113

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

2906

List out the buffer pools in db2

1060

What is the physical storage length of timestamp data type?

1074

What is the physical storage length of the data types: date, time, timestamp in the db2 database?

1139

How to connect to db2 database from windows command line?

1040

What is load replace in db2?

981

Why do we need reorg in db2?

971

What is alias in db2?

1027

How to find schema of a table in db2?

1000

What is the max length of sqlca?

1206

What is syscat in db2?

986

What is sqlca’s maximum length?

1152

What is the use of with ur in db2?

1034