Do we need cursor for Count(*)?

Answer Posted / shravan kumar.p

no need..
select count(*) from the emp.
it will give the total no of rows in a table..

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the clustering index in the db2 database?

739


How does cobol compile db2 program?

800


How can deadlocks be resolved?

712


How to rename a table in DB2 ?

800


Define db2 and its databases?

799


How to fetch the last row from the table in SQL (db2)?

1277


What is null indicator in db2?

818


What are the two types of logging in the db2 database? Explain them.

764


When do you specify the isolation level?

783


How to connect to db2 database from windows command line?

782


Why cursor is used in db2?

754


I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?

2128


How to find the maximum value in a column in the db2 database?

804


What is the usage of open cursor command?

765


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

900