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

What is the difference between a package and a plan?

6 Answers   Infosys, L&T, Mphasis,


Why do we need to create an alias if we can directly use the table name? What are the benefits of referring a table name by its alias? Also, when should we go for alias and when for synonyms?

1 Answers  


Which is faster delete or truncate?

0 Answers  


What is a Resource Control Table(RCT)? Describe its characteristics.

3 Answers  


db2 restart logic ?

1 Answers   DELL, HTC, UHG,






What is dclgen in db2?

0 Answers  


What is view db2?

0 Answers  


What is the purpose of rollback and commit?

0 Answers  


Where besides the DB2 catalog is database object information stored by DB2?

1 Answers  


How would you move a tablespace (using STOGROUP) to a different DASD volume allocated to that tablespace?

1 Answers  


What is the picture clause of null indicator variable?

0 Answers  


What is reorg in database?

1 Answers  


Categories