Interested to Buy Any Domain ? << Click Here >> for more details...
How will you delete duplicate records from a table?
- 7 Answers
- 24772 Views
- Google, I also Faced
- E-Mail Answers
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 can record locking be achieved in those DB2 versions which do not support it?
What is the reason behind not using select * in embedded sql programs?
What is dbrm? What it contains?
What is the physical storage length of timestamp data type?
What is db2 command?
How do I create a view in db2?
What is meant by union and union all?
How to take backup of table in db2?
What is dbrm in db2 database?
What is a bind in db2?
by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?
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 parameters are used to control the free space in DB2?
Explain packages.
Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?
