How will you delete duplicate records from a table?
Answer Posted / tharanath.n
delete from table a
where rowid >(select min(rowid) from table b
where a.column = b.column);
Is This Answer Correct ? | 13 Yes | 5 No |
Post New Answer View All Answers
How do I import a csv file into db2?
Mention the way of highlighting as well as putting a cursor to use in a cobol program.
List out the data types available.
What is an instance in db2?
Explain the contention situations caused by locks?
What is the physical storage length of the data types: date, time, timestamp in the db2 database?
SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD CHAR, TOKEN KEY was expected
Which component is responsible for processing sql statements and selecting access paths?
Explain how can you do the explain of a dynamic sql statement?
Mention some fields that are a part of sqlca.
How can you quickly find out the # of rows updated after an update statement?
What is a plan and package in db2?
Comment whether the cursor is closed during commit or not.
Define predicate?
How do I delete a table in db2?