hi try with key word 'rownum' and 'rowcount' ex: de

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

Question Posted / ankit

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

Please Help Members By Posting Answers For Below Questions

What are packages in db2?

1030

Explain the function of data manager.

1052

Define buffer pool.

1065

What is rct?

1247

What is the difference between drop table and delete table?

1226

What are iseries servers?

1087

What is cursor stability in db2?

1366

What are the prerogatives?

1091

What do you mean by commit and rollback?

1055

How to check last update on table in db2?

1069

What is the difference between spufi and qmf?

1140

What is deadlock in db2?

1076

Explain about rct in db2?

1119

How do we specify index to include or not during bind process.

2137

What is a trigger in the db2 database?

1101