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...

i want to delete 20th million record how ?

Answer Posted / magesh

delete from (select row_number() over() as COLUMN1 from
TABLE_OWNER.TABLE_NAME )
where COLUMN1=20000000;

Is This Answer Correct ?    0 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Define check constraint.

1028


What is cursor stability in db2?

1280


How to check sequence on a table in db2?

997


What is lock escalation in db2?

969


What is the connection string to connect to the DB2 Database ?

1062


What is database alias db2?

1067


How to create db2 table in mainframe?

1105


What is the max length of sqlca?

1160


What is the difference between plan and package in db2?

1039


What is db2 look?

971


How would you find out the total number of rows in a db2 table?

990


What do you mean by storage group (stogroup)?

984


What does a deadlock mean in DB2?

1099


What are packages in db2?

973


Can we update view in db2?

947