Exforsys
+ Reply to Thread
Results 1 to 2 of 2

Retain Duplicate

This is a discussion on Retain Duplicate within the DB2 forums, part of the Database category; I want to retains duplicates in my DB2 database while outputting the result.How can I achieve this. If someone could ...

  1. #1
    cyrus is offline Senior Member Array
    Join Date
    Apr 2006
    Answers
    128

    Smile Retain Duplicate

    I want to retains duplicates in my DB2 database while outputting the result.How can I achieve this. If someone could give me syntax with example I could finish the process.


  2. #2
    Adrian is offline Senior Member Array
    Join Date
    Apr 2006
    Answers
    124
    You can use the clause named as UNION ALL in DB2 query to achieve your desired result. Try and let us know whether you got the result and if you need further help on this.


Latest Article

Network Security Risk Assessment and Measurement

Read More...