Interested to Buy Any Domain ? << Click Here >> for more details...
Do we need cursor for Count(*)?
- 4 Answers
- 9179 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 |
Assuming that a site's standard is that pgm name = plan name, what is the easiest way to find out which Will precompile of an DB2-COBOL program bomb, if DB2 is down?
Define buffer pool.
What is subquery ?
is it compulsory commitment control in journal?
wht r the requirements for writing a cobol-db2 pgm ?
What are the contents of dclgen?
What is the self-referencing constraint?
What is db2 command?
What is a result table?
in GDG: is it poosible to copy records from a file which utilizes some 100 cylinders to a gdg whose model is defined as trk(1,0) and also it possible to copy 100 bytes file to 80 bytes file?
How do run the JCL which has 25 steps by skipping the following steps 5, 10,15 and 25 without using COND statement
What is the role of the data page in the db2 database?
COBOL 
