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

When do you specify the isolation level?

1030

What is cobol db2?

1000

What is the use of value function?

1150

What is bind and rebind in db2?

1137

Can we delete records from view?

967

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

1110

How can deadlocks be resolved?

936

If the cursor is kept open followed the issuing of commit, what is the procedure to leave the cursor that way?

1146

List out the three types of page locks that can be held.

1149

What are the contents of dclgen?

1112

What is the function of logging in the db2 database?

1121

How do I optimize a query in db2?

1101

Which component is used to execute the sql statements?

1096

Define buffer pool.

1054

What are types of indexes?

1072