Interested to Buy Any Domain ? << Click Here >> for more details...
How will you delete duplicate records from a table?
- 7 Answers
- 25107 Views
- Google, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / ajay kumar ande
question is wrong......records-----files,table-----rows
How will you delete duplicate records(rows) from a table?
pgm=sort
sortin dd dsn=-----
sortout dd dsn=-----
sysin dd *
sort fields=(2,3,ch,a)
sum fields=none ------>eliminates duplicate recs
| Is This Answer Correct ? | 3 Yes | 1 No |
Answer / venkat
delete from emp where ecode IN ( select ecode from emp group by ecode having count(*) >1 )
| Is This Answer Correct ? | 5 Yes | 4 No |
Answer / mehdee
Hi. This is a database design problem, because if you
alowe duplicate rows then you must have at least a column
being like squence number.
| Is This Answer Correct ? | 2 Yes | 2 No |
Answer / naresh.s
in DB2
first we need to know duplicate records in database file
like tmpfilep ,for that
select RRN(A) from tmpfilep A where field='fieldvalue'
here field means any fileld containd tmpfilep and
corresponding value.
once we execute the above query we will get relative record
numbers of each row and remember that numbers
now you can delete records based on these numbers
delete from tmpfilep A where rrn(A) in (234,341,642)
here 234,341,642 are sample record numbers
may be i am correct upto my knowledge.......
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / 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 |
Answer / s
DELETE FROM TABLE ABC
WHERE COLUMN =
(SELECT COLUMN FROM TABLE ABC
GROUP BY COLUMN
HAVING COUNT(*) > 1);
| Is This Answer Correct ? | 20 Yes | 36 No |
What should be specified along with a cursor in order to continue updating process after commit?
what is dynamic cursor?gives syntax for this?
I have a table(product),It contain fields(productname,cost). I want to retrieve the product name ,which cost is second maximum in the table?
Explain packages.
What is package in db2 mainframe?
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?
how to delete perticular row from table for ex. how you will delete 3rd row from table please answer THANKS IN ADVANCE
How do I add a column in db2?
What is a composite index and how does it differ from a multiple index?
How do I change the column size in db2?
What are packages in db2?
What is null indicator in db2?
COBOL 
