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

What are db2 objects?

1035


What is dpf in db2?

1089


What is declare cursor?

1104


Before you give the explain statement, what are the prerogatives?

1014


How to find the maximum value in a column in the db2 database?

1061


Mention the definition of cobol in varchar field.

1227


What is a bind in db2?

1022


What is package in cobol db2?

1107


How do you simulate the explain of an embedded sql statement in spufi/qmf?

1068


Why do we need reorg in db2?

971


What is the use of value function?

1128


I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?

2371


what is db2 restart?

2135


Which command is used to remove all rows from a table?

1091


What is buffer pool in the db2 database?

1081