Answer / mithlesh

delete from table_name
where address = '456' and '678'.

Answer / siri

DELETE FROM TABLE WHERE ADDRESS IN('456','678')

Answer / prashant shettar

delete from (select rownumber() over() as rowid from tab1 )
where rowid = ( (select count(*) from tab1) - 1)

Answer / suv

We can use concept of cursor to delete particular row. The
row where the cursor is pointing will get deleted.

Please correct is wrong..

Answer / vaneesh khurana

I think better to perform this in following 2 queries

1. Select count(WS-COUNT) from TABLE;

2. DELETE FROM TABLE WHERE ROWCOUNT(*) IS WS-COUNT OR
(WS-COUNT-1);

Basically here the first row will give you the record count
and 2nd will delete the last and the 2nd last row.

How can you do the explain of a dynamic sql statement?

0 Answers  

What error I will get if my select query gives multiple row while executing a Cobol-DB2 program.How can I solve it without using a cursor.

4 Answers   Cap Gemini, Verizon,

What is dbrm? What it contains?

0 Answers  

What is the difference between group by and order by?

2 Answers   IBM, TCS,

When you are working with the project after coding what will u do? Like what type of documents u will prepare? How will u do testing?

2 Answers  

What is declare cursor?

0 Answers  

select distinct(empid),distinct(dept),name from EMP will the above query work?

2 Answers   CTS,

How to find the number of rows in db2 tables?

0 Answers  

what is the process of precompiler?

2 Answers  

Mention the way of highlighting as well as putting a cursor to use in a cobol program.

0 Answers  

What are simple, segmented and partitioned table spaces ?

1 Answers   TCS,

Once you create a view, where would information about the view be stored?

1 Answers