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 / ankit

hi

try with key word 'rownum' and 'rowcount'
ex: delete from table where rowcount=3;

correct me if i am wrong

Is This Answer Correct ?    3 Yes 11 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the syntax for FETCH in DB2 ?

1267


What is dbrm? When it will be created?

1085


Explain the benefits you can get from mainframe connect?

1015


Is ibm db2 open source?

1128


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

707


What is the maximum size of a char data type in db2?

1050


What is reorg and runstats in db2?

1260


How does cobol compile db2 program?

1128


How and when does the db2 enforces the unique key?

1141


How do we specify index to include or not during bind process.

2173


What is the difference between using bind () and rebind () methods of naming class?

1454


What do you mean by rollback?

1030


How to create backup table in db2?

1149


What is ibm db2 connect?

1054


What is universal database?

1118