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
15059 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

More DB2 Interview Questions

Is db2 a programming language?

0 Answers

What are the contents of a dclmgen?

0 Answers

Where could you look if you had a question about whether a column has been defined as an index?

2 Answers

Suppose we have a query for update update table1 set col1 = 'val1' where col2=(select .... from ...) suppose the subquery does not return any record, what will happen to update?

1 Answers IBM,

What is a LIKE table and how is it created?

2 Answers

How many Buffer pools are there in DB2 and what are they?

1 Answers IBM,

Where to download IBM DB2 Certification Dumps for the below: C2090-311 : IBM DB2 10.5 DBA for LUW Upgrade from DB2 10.1 C2090-312 : IBM DB2 11 DBA for z/OS C2090-313 : DB2 11 Application Developer for z/OS C2090-317 : DB2 11 System Administrator for z/OS C2090-541 : DB2 9.7 DBA for Linux UNIX and Windows C2090-543 : DB2 9.7 Application Development C2090-544 : DB2 9.7 Advanced DBA for LUW C2090-545 : DB2 9.7 SQL Procedure Developer C2090-546 : DB2 9.7 Database Administrator for Linux UNIX or Windows Upgrade C2090-610 : DB2 10.1 Fundamentals C2090-611 : DB2 10.1 DBA for Linux, UNIX, and Windows C2090-612 : DB2 10 DBA for z/OS C2090-614 : DB2 10.1 Advanced DBA for Linux UNIX and Windows C2090-615 : DB2 10.5 Fundamentals for LUW C2090-617 : DB2 10 System Administrator for z/OS C2090-730 : DB2 9 Family Fundamentals C2090-733 : DB2 9 Application Developer C2090-735 : DB2 9.5 SQL Procedure Developer C2090-737 : DB2 9 System Administrator for z/OS Exam

1 Answers Mphasis,

What is db2? Explain.

0 Answers

What is meant by isolation level?

3 Answers

why should we bind the DB2 program . What if we did not BIND a BD2 program ??

9 Answers Infosys, TCS, Xansa,

Are views updateable?

0 Answers

What are packages in db2?

0 Answers

For more DB2 Interview Questions Click Here