Interested to Buy Any Domain ? << Click Here >> for more details...
How will you delete duplicate records from a table?
- 7 Answers
- 25036 Views
- Google, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
List down the data types in the db2 database.
Is it possible to create an Instance in DB2 using DB2 Control Center ?
Is db2 free?
Which command is used to remove all rows from a table?
What is coalesce in db2?
What is node in db2?
What is meant by union and union all?
What is a buffer in memory?
Is ibm db2 open source?
What is the difference between cursor stability and repeatable read isolation levels?
Mention the location where the output received from explain statement is stored.
How to run db2 command in windows?
Is it possible using max on a char column?
What is the picture clause of null indicator variable?
How do I add a column to a table in db2?
