Interested to Buy Any Domain ? << Click Here >> for more details...
are we use the group by clause in cursors?
- 3 Answers
- 10300 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 |
Reading a record from a TSQ will logically delete the record from the Queue (True or False).
What is the function of the CICS translator?
How to get the cursor position when we receive a map?
How and where is the TWA size set? .
Explain the function of the load command?
What is DFHBMSCA?
list the sequence of steps used to achieve modiication in skip sequential mode?
How do you access the records randomly in TSQ ?
What is bms map?
What is the option specified in the read operation to gain multiple concurrent operations on the same dataset?
What is the common systems area (CSA)?
Define transient data?
COBOL 
