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 / prashant shettar

delete from (select rownumber() over() as rowid from tab1)
where rowid =3

Is This Answer Correct ?    2 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

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

2310


What is concurrency?

1306


Which components manage deadlocks in db2?

1127


What is the physical storage length of the data types date, time, and timestamp?

1142


What is reorg?

1245


What is db2 look?

1079


How do I delete a table in database?

1079


How can record locking be achieved in those DB2 versions which do not support it?

1132


I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?

2441


What is db2 optimizer?

1316


What is difference between rollback and commit?

1206


What is null indicator in cobol db2?

1113


What is bind and rebind in db2?

1191


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

1085


What are the full forms of spufi and dclgen and why are they used?

1138