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

Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?

1147


What is sqlca’s maximum length?

1250


What is query_cache_limit?

1036


What is phantom read in db2?

1226


What are iseries servers?

1135


Define db2.

1172


Define data page.

1133


What is the use of db2 optimizer?

1175


What is check constraint. Explain with example.

1163


can any one provide me the link for the db2 v7 & db2 v8 manual for Z/os? i need to know about the syntax of REORG in both versions & need to know the difference as well

2297


Give a brief description of db2 isolation levels?

1141


What are the rules for db2 programming?

1155


Differentiate between cs and rr isolation levels? Where do you specify them?

1121


What r the comman abends in db2, jcl and cobol???????

2309


What is a db2 collection?

1110