In my table having 3000 Records. How can I delete the 500th row? (we don'

In my table having 3000 Records. How can I delete the 500th
row? (we don't know what is data inside the table)

Question Posted / rafee.mfs

3 Answers
10488 Views
Keane India Ltd, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

In my table having 3000 Records. How can I delete the 500th row? (we don't know what is data ..

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

In my table having 3000 Records. How can I delete the 500th row? (we don't know what is data ..

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

In my table having 3000 Records. How can I delete the 500th row? (we don't know what is data ..

Answer / venkata subbaiah

Delete from table where rowid=500;

Is This Answer Correct ?

1 Yes

6 No

Post New Answer

More COBOL Interview Questions

WORKING-STORAGE SECTION. 01 VAR1 COMP-2 VALUE 0. PROCEDURE DIVISION. MOVE 10.2115 TO VAR1. DISPLAY 'VAR1 =' VAR1. GOBACK. 10.2115 is stored as .10211499999999996E 02 in OS VS Cobol 10.2115 is stored as .10211500000000000E 02 in ecobol. Any reason why?

3 Answers TCS,

what is the advantage of using redefines instead of delaring the variables ?

5 Answers HCL,

which is Best IBM Mainframe Training and Placement Institute in Ameerpet Hyderabad

1 Answers

How you can read the file from bottom?

1 Answers

Hi, My interviewer ask A calls B and C calls B, a and b are static c and b are dynamic.what happens if they compile and execute at same time.

3 Answers iGate,

How to retain the Duplicates in the one records?

3 Answers CS,

In A cobol program , we can use COPY Statement in FILE- SECTION / WORKING-STORAGE SECTION / ENVIRONMENT DIVIION basically what is the difference