Do we need cursor for Count(*)?

Question Posted / rajesh_m13

4 Answers
7521 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