 |
 |
Archives of the TeradataForum
Message Posted: Tue, 23 Aug 2005 @ 20:35:20 GMT
| Subj: | | Re: Unexpected handling of duplicate results |
| |
| From: | | Mike Felts |
| | UNION removes exact duplicate rows; if you want to retain them, use UNION ALL. | |
I knew that UNION removed duplicate records between datasets (so if set A has record 1 in it and set B has record 1 in it, record 1 would only
be returned once) but I didn't realize it removed duplicates from within the datasets as well (so if set A has record 1 in it twice and set B has
record 1 in it, record 1 would only be returned once instead of twice), though I guess it somewhat makes sense to me.
Mike
| |
