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
9044 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 null indicator in db2?

1120

What is phantom read in db2?

1165

What is package in cobol db2?

1121

Define check constraint.

1084

How do you stop a db2 database in linux?

1020

What is a db2 cursor?

1064

What is a dbrm in db2?

1031

What kind of database is db2?

1038

I HAVE 500 ROW TO UPDATE I WOULD LIKE TO USE ROLLBACK ALONG WITH COMMIT.WHAT IS THE SYNTAX TO CODE COMMIT AND ROLLBACK FOR EVERY 100 ROWS.AND HOW THE CURSOR ROLLBACK TO THE LAST COMMITTING POINT.

3218

What is db2 bind process?

1246

Explain about open switch business continuity software?

1140

What is db2 command?

1043

What is the information associated with sysibm.syslinks table?

1129

How do I add a column to an existing table in db2?

1032

Mention the definition of cobol in varchar field.

1250