Interested to Buy Any Domain ? << Click Here >> for more details...
are we use the group by clause in cursors?
- 3 Answers
- 10447 Views
- Cap Gemini, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / bubbles
We can use group by in cursors, but not when using
aggregate functions like Distinct,Max etc
| Is This Answer Correct ? | 20 Yes | 2 No |
Answer / suma
We can use group by clause in cursor. But when used the
cursor is not updatable.
| Is This Answer Correct ? | 3 Yes | 1 No |
Answer / madhusudhana
No we cant use group by clause in cursor because a GROUP BY
may be used on a column(s) but not on row(s)
| Is This Answer Correct ? | 4 Yes | 9 No |
What is the content of the PPT entry?
Which is the EIB field that gives the date when a task was started?
What is the most common way of building queue-id of a TSQ? (Name the constituents of the Queue ID).
How To Set MDT(Modified Data Tag) Thru Application Program? (Dynamically)?
What other file control processing commands are used for file updating?
How do you rollback data written to an ESDS file?
What is the primary function of the Sign-on Table?
Is it possible start a transaction CICS from job Batch? How do it?
What is the difference between a Symbolic map and Physical map ?
Explain the difference between a return with transid and xctl? For example program. A is issuing return with transid to program b. Program a. Is isssuing xctl to program b?
Explain the various ways data can be passed between CICS programs.
For multithreading an application program need not be re- entrant(True or False).
COBOL 
