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 100 Rec. How can I delete the 7th row??
(we don't know what is data inside the table)

Answer Posted / m sharib

delete from table1 where policy_no =(select policy_no from table1 limit 6,1);

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain the contention situations caused by locks?

1023


What is the use of predicate?

1001


Is db2 a mainframe?

991


What is dbrm library?

1016


Hello All, We have requirment to Replace BMC Db2 Load product thru CA FAST LOADPlus product. Do anyone have JCL to for FAST LOADPLUS and what all are thing need to take in consideration.

2682


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

987


How connect db2 database to datastage?

1198


What is dbrm? When it will be created?

978


What is declare cursor?

1060


What is database alias db2?

1076


Is ibm db2 open source?

1030


Comment whether dclgen is mandatorily used. If not, then what is the point of using it?

1024


What is the use of db2 optimizer?

1067


What is sqlca?

1011


What is collection in db2 bind?

972