Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How did the release of cobol/370 version 1.3 improve the performance of release 1.1?

1077


What are INPUT PROCEDURE and OUTPUT PROCEDURE?

1293


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

2072


What are the rules of the move verb?

1260


can anybody post me about file-aid and changemen tools pls and give me reference if any mainframe guys are there

2469


What rules are to be followed while using the corresponding options?

1058


What is Pic 9v99 Indicates in COBOL?

1253


What is a SSRANGE and NOSSRANGE?

1461


Why occurs cannot be used in 01 level in COBOL?

1156


How do you differentiate between cobol and cobol-ii?

1204


State the various causes of s0c1, s0c5 and s0c7.

1075


how do you reference the rrds file formats from cobol programs

1571


How can i load all the data from a file to Table (array) in cobol.How i manage the occurs clause with out reading the file.Any options avilable ? Please can any one help me it is urgent?

2579


Explain what you understand by passing by value.

1144


I have a File that has duplicate records. I need only those records that occur more than thrice.?

9873