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

how to delete perticular row from table
for ex. how you will delete 3rd row from table
please answer
THANKS IN ADVANCE

Answer Posted / anjireddy vintha

delete from tablename where rownum=3

Is This Answer Correct ?    0 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How is a typical db2 batch pgm executed?

1185


What are packages in db2?

1028


What is lock escalation in db2?

1041


by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?

9232


What is cascading rollback?

1220


How to view db2 table structure?

1022


What is ibm db2 used for?

1091


What are the different types of base tables?

1102


What is deadlock in db2?

1076


What is dclgen in db2?

1156


How do I import data from excel to db2?

1078


What is the purpose of rollback and commit?

1203


What is buffer pool and list some of them?

1046


What is meant by explain?

1140


In case if at some point of time db2 is down, would that impact the pre-compilation process of a db2-cobol program?

1054