Do we need cursor for Count(*)?

Question Posted / rajesh_m13

4 Answers
9034 Views
iGate, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

Do we need cursor for Count(*)?..

Answer / 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

Do we need cursor for Count(*)?..

Answer / yaswanth

we will use cursors when we have situation like the query
returning multiple rows but in this case
select Count(*) from EMP table where EMPNAME='some' will
return only one row, i.e how many rows it found with
EMPNAME='some' eg:3 or 4 or 5 ... so there is no concept of
cursor here

Is This Answer Correct ?

9 Yes

3 No

Do we need cursor for Count(*)?..

Answer / 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

Do we need cursor for Count(*)?..

Answer / sachin borase

select 8 from table fetch first 3 rows only

Is This Answer Correct ?

0 Yes

5 No

Post New Answer

More DB2 Interview Questions

how 2 resolve the -311 sqlcode

1 Answers

How to resolve -502 sql code in DB2?

2 Answers Cap Gemini,

In BIND, isolation level parameter specifies the duration of page lock and ACQUIRE, RELEASE also do almost the same thing. What is the exact difference between the two? Do they work in conjunction while executing SQL queries and obtaining locks?

8 Answers Syntel,

Return code 100 means?

6 Answers Cap Gemini,

I have a table name Table1 which contain columns Cust_no, car_model, country, salesamt. The records are 101, Fiat, India, 12345 2nd record is 102, Tata, USA, 98743 3rd record is 101, indica, India, 65342 4th record is 103, Toyota, UK, 64522 5th record is 103, Maruti, USA, 98632 and so on..... Now my question is write sql query which will give me detail about the sum of sales amount in perticular country

2 Answers IBM,

How would one remove old reorg information from the DB2 catalog?

2 Answers

What is scrollable cursor in db2?

0 Answers

when does the SQL statement gets executed when you use cursor in the application programming ?

3 Answers IBM,

What are db2 error codes -305 and -407. What is the difference between these 2 error codes ?

1 Answers

how do you resolve -818 error in db2. where we have to see time stamp token. i said by seeing in load module and plan .is it correct or not. give clear explination for how to see time stamp token

2 Answers IBM, TRD,

Is there any advantage to denormalizing DB2 tables?

1 Answers

What is dclgen in db2?

0 Answers

For more DB2 Interview Questions Click Here