How will you delete duplicate records from a table?
Answer Posted / king
DELETE FROM FILE WHERE FIELD = ALL(SELECT FIELD FROM FILE
GROUP BY FIELD HAVING COUNT(*) > 1)
OR
DELETE FROM FILE WHERE FIELD = ANY(SELECT FIELD FROM FILE
GROUP BY FIELD HAVING COUNT(*) > 1)
| Is This Answer Correct ? | 1 Yes | 7 No |
Post New Answer View All Answers
What is page size in db2?
Mention the length of physical storage of the given data types of db2 – date, timestamp, time
Discuss about db2 bind?
What is reorg?
How do you concatenate the firstname and lastname from emp table to give a complete name?
Define buffer pool.
What is clone table?
Explain in brief how does db2 determine what lock-size to use?
in my project..TEST is db2 8.1 version In PROD it is 7.1 if i do REORG in TEST.. can I use the same REORG jcl with out modification in PROD region (this is DB2 8.1 )? if not, what modification i need to do in my REORG control card?
What is the maximum size of varchar data type in db2?
Mention the various locks that are available in db2.
What is the maximum size of a char data type in db2?
What is explain in db2?
List down the data types in the db2 database.
How to view db2 table structure?