Interested to Buy Any Domain ? << Click Here >> for more details...
Do we need cursor for Count(*)?
- 4 Answers
- 9051 Views
- iGate, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
Answer / sachin borase
select 8 from table fetch first 3 rows only
| Is This Answer Correct ? | 0 Yes | 5 No |
WHAT IS MEANT BY COMMIT COMMAND?
wht displays the number of times a query modified ?
What is lock escalation in db2?
What is read-only cursor?
How to take backup of table in db2?
What is null indicator in db2?
What is the difference between dbm cfg and db cfg file in db2 ?
what types of copies can be made with the COPY Utility ?
What is the syntax for seeing the columns and data types of a table in the db2 database?
What is commit in db2?
what is datacom db?
What is IMAGECOPY ?
COBOL 
