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

Answers were Sorted based on User's Feedback



how to delete perticular row from table for ex. how you will delete 3rd row from table please answ..

Answer / krishna

Delete from TAb1
Where Rowcount(*)=3

i hope this is Correct

Is This Answer Correct ?    5 Yes 1 No

how to delete perticular row from table for ex. how you will delete 3rd row from table please answ..

Answer / prashant shettar

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

Is This Answer Correct ?    2 Yes 2 No

how to delete perticular row from table for ex. how you will delete 3rd row from table please answ..

Answer / siri

DELETE FROM TABLENAME WHERE <3ROW>=VALUE

Is This Answer Correct ?    0 Yes 0 No

how to delete perticular row from table for ex. how you will delete 3rd row from table please answ..

Answer / avi

When you are saying row no 3 , means your data is in sorted format and table having the primary key , so find the row no 3 primary key information and then delete it using the where clause with primary value .

Is This Answer Correct ?    0 Yes 0 No

how to delete perticular row from table for ex. how you will delete 3rd row from table please answ..

Answer / santhu

i think each row we can identify using ROWID . using ROWID
we can delete the row like fallowing

delete from <table_name> where rowid=3


correct me if i am wrong........

Is This Answer Correct ?    0 Yes 1 No

how to delete perticular row from table for ex. how you will delete 3rd row from table please answ..

Answer / dalwinder singh

delete from (SELECT * FROM (SELECT col1,rownumber() over()
as rn from table where col =value) as tr where rn = 3)

Is This Answer Correct ?    3 Yes 5 No

how to delete perticular row from table for ex. how you will delete 3rd row from table please answ..

Answer / anjireddy vintha

delete from tablename where rownum=3

Is This Answer Correct ?    0 Yes 2 No

how to delete perticular row from table for ex. how you will delete 3rd row from table please answ..

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

how to delete perticular row from table for ex. how you will delete 3rd row from table please answ..

Answer / shiva

delete from table where rowcount=3;

Is This Answer Correct ?    1 Yes 9 No

how to delete perticular row from table for ex. how you will delete 3rd row from table please answ..

Answer / guest

press delete

Is This Answer Correct ?    4 Yes 36 No

Post New Answer

More DB2 Interview Questions

How do I add a column to a table in db2?

0 Answers  


How do you stop a db2 database in linux?

0 Answers  


Explain package in db2 and its advantages?

0 Answers  


What is Reorg Recovery? when will you run it?

2 Answers  


What is commit in db2?

0 Answers  


Which component is responsible for processing sql statements and selecting access paths?

0 Answers  


What is runstats utility in db2?

0 Answers  


what is difference between random and sequence file access

1 Answers   Syntel,


Where do you specify them?

0 Answers  


What is a cursor and what is its function?

2 Answers  


Why do we bind in db2?

0 Answers  


How can i install db2 9.x on AIX based system..? plz reply the detailed steps involved....?

0 Answers   IBM, TCS,


Categories