Exforsys

Free Training

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 ...

Go Back   Exforsys > Database > DB2

Exforsys.com


DB2 DB2 Programming help and Discussions.

Reply

 

LinkBack Thread Tools Search this Thread
  #1 (permalink)  
Old 12-20-2006, 03:10 PM
Senior Member
 
Join Date: Apr 2006
Posts: 153
cyrus is on a distinguished road
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.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Sponsored Links
  #2 (permalink)  
Old 03-13-2007, 10:09 PM
Senior Member
 
Join Date: Apr 2006
Posts: 141
Adrian is on a distinguished road
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.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply

Bookmarks

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads

Thread Thread Starter Forum Replies Last Post
Eliminating Duplicate Rows from Flat File cyrus Data Warehousing 2 08-24-2007 08:16 AM
How to delete duplicate rows from a table athermaliq Oracle Tutorials 5 01-17-2006 12:03 AM
[FAQ] FileMaker Pro - database for Macintosh and Windows Martin Trautmann Tech FAQ 0 04-17-2004 07:26 AM


All times are GMT -4. The time now is 05:45 PM.


Powered by vBulletin® Version 3.8.4
Copyright ©2000 - 2010, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.3.0
Copyright 2004 - 2009 Exforsys Inc. All rights reserved.