SELECT * FROM (SELECT col1,col2,col3, rownumber() over() AS rn FROM tab1) a

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 / suraj kumar pathak

Answer Posted / 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

Please Help Members By Posting Answers For Below Questions

What is report-item in COBOL?

1141

Why is it necessary that file needs to be opened in I-O mode for REWRITE?

1307

Write a cobol program making use of the redefine clause.

1150

how to move the records from file to array table. give with code example

2657

i need a small 3d program using inline and outline.

2195

how to access the file from prodution from changeman tool and to submit a file to production

7520

What are different data types in cobol?

1292

Why did you choose to work with ibm mainframe cobol programming?

1086

For rewrite, why is it mandatory that file needs to be opened?

1088

i want a program using by if, evaluate , string, unstring, perform, occurs?

4704

Can we change the password using ALTER? anyone tried and changed?

1993

What is an in line perform? When would you use it? Anything else you wish to say about it.

1061

What are the different rules for performing sort operation?

1204

What are the different rules to perform a Search?

1079

What is the compute verb? How is it used?

1120