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

Categories >> Software >> MainFrame >> IBM MainFrame >> DB2
Suggest New Category

how to delete perticular row from table
for ex. how you will delete 3rd row from table
please answer
THANKS IN ADVANCE

Question Posted / guest

10 Answers
14632 Views
IBM, I also Faced
E-Mail Answers

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