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 are the different data types in cobol?

1335

How do you get the data to code the BMS macro?

1922

what is the difference between COBOL2 AND COBOL390?

2988

What is the difference between a binary search and a sequential search what are the pertinent cobol?

1095

What is the default value(s) for an initialize? What keyword will allow for an override of the default?

1064

What is Pic 9v99 Indicates in COBOL?

1179

how can we apply for HSBC exam(Mainframe) in India??? i went to their site and was told to submit my CV ,. etc..( totally confusing...)

2337

how to convert the recors form vsam file to db2 table tru file aid

3213

If you are current on the owner of a set, what is the difference between obtain next and obtain first?

1232

if we have " ibm mainframe ",in that how to remove first and last leading space eg:"ibm mainframe" like that the answer we need

1293

System Testing for Mainframe Developers What is System Testing? integration testing ? what's the procedure ..

2015

What is the usage of comp fields in cobol?

1132

What are the different types of condition in cobol and write their forms.

1065

What is the difference between Structured COBOL Programming and Object Oriented COBOL programming?

1057

Whats the difference between search & search ALL?

6365