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

What is check constraint in db2?

1012


What is db2 stogroup?

1095


Which command is used to connect to a database in DB2 ? Give the Syntax.

1030


Is db2 free?

1036


define clustering index.

978


What is the cobol picture clause of the db2 data types date, time, timestamp?

1009


What is a collection in db2?

983


What is the purpose of rollback and commit?

1086


Cursors can be declared in both working-storage & procedure division, agreed. But is there any difference? If could you please suggest what is the difference

1310


What parameters are used to control the free space in DB2?

1008


How can we retrieve the total number of records in RPG & CLLE?

577


Explain various types of locks in db2?

1081


What is the role of union all and union

1069


What is a db2 tablespace?

998


My sql statement select avg(salary) from emp yields inaccurate results. Why?

1032