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

Why do we need reorg in db2?

1040


What is buffer pool?

1158


What is query_cache_limit?

1033


How to find schema of a table in db2?

1064


How do I change the column size in db2?

1205


Which are the db2 tools to protect integrity of the database?

1166


What is data manager?

1101


What is reorg?

1238


What is the purpose of using commit?

1149


Define data page.

1126


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

1154


What is the difference between oracle and db2?

1167


What is difference between isnull and coalesce?

1104


How to find primary key of a table in db2?

1112


Explain dclgen.

1268