In my table having 3000 Records. How can I delete the 500th
row? (we don't know what is data inside the table)
- 3 Answers
- 9582 Views
- Keane India Ltd, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / pratap
delete from table where ROWNUM = 500;
As per IBM notes ROWNUM is support feature in DB2.
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / suraj kumar pathak
SELECT * FROM (SELECT col1,col2,col3, rownumber() over() AS rn FROM tab1) as tr WHERE rn = 500;
| Is This Answer Correct ? | 4 Yes | 5 No |
What is the difference between a DYNAMIC and STATIC call in COBOL?
CAN ANY ONE HELP WHAT IS QTP? why it is nessery AND WEN IT IS USED?
What is rmode(24)
How arrays can be defined in COBOL?
Can we move X(7) to S9(7) COMP?
In COBOL programming, what is PERFORM? What is VARYING?
When and how can we use index & subscript ?
i WANT ALL ERROR codes IN CICS and DB2
why 02 level number can't be use as a separate level number like 01 or 77 ?
if you code move high-values to variable,can you move it into numeric variable or alphanumeric variable?
What are the different rules for performing sort operation?
In a program, there are 2 sections defined say SECTION-A and SECTION-B. There is a paragraph say CALC-INT in both the sections. If this para has to be called directly for SECTION-A, then PERFORM CALC-INT will not work as it is present in both sections. How the PERFORM statement has to be coded here?
COBOL 
