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 physical storage length of date data type?

1191


Explain how can you do the explain of a dynamic sql statement?

1066


What action db2 takes when a program aborts in the middle of a transaction?

1092


How can the duplicate values be eliminated from db2 select?

1044


Is ibm db2 free?

955


What is the use of reorg in db2?

1027


What is database reorganization?

1056


How do you concatenate the firstname and lastname from emp table to give a complete name?

1016


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

1025


Explain about rct in db2?

1046


What is a page in db2?

983


Why cursor is used in db2?

986


Explain the function of data manager.

993


Explain package in db2 and its advantages?

1139


What is the cobol picture clause of the db2 data types date, time, timestamp?

1012