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 / rajesh

Hope this will do.

delete from tbname where rowcount(*) = 200000 ;

Is This Answer Correct ?    8 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is innodb buffer pool?

1052


What is the result of open cursor statement?

1083


How to check last update on table in db2?

1059


Why select is not preferred in embedded sql programs?

1299


What is copy pending and check pending in db2?

1004


What is dbrm? When it will be created?

1029


What is meant by explain?

1133


Explain about open switch business continuity software?

1133


How do you pull up a query which was previously saved in qmf?

1149


What is the difference between cursor and select statement?

1101


How do I connect my db2 database to ibm?

1050


Mention the various locks that are available in db2.

1039


What is cursor in dbms?

1064


What is the role of the data page in the db2 database?

1028


What is syscat in db2?

1010