Exforsys

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


Go Back   Exforsys > Database > DB2

Retain Duplicate Retain Duplicate

Register FAQ Members List Calendar Search Today's Posts Mark Forums Read

Reply

 

LinkBack Thread Tools
  #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
  #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

« To find Maximum | About Certification »

Thread Tools

Posting Rules
You may not post new questions
You may not post replies
You may not post attachments
You may not edit your posts
vB 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 02:36 PM.

Contact Us - Exforsys - Archive - Privacy Statement - Top

Powered by vBulletin® Version 3.6.8
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.1.0
Copyright 2004 - 2007 Exforsys Inc. All rights reserved.