Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB Enhancement Requests and Suggestions » View Thread |
Messages 1 to 4 of 4 total |
Can we have CLOBs in a UNION please |
Wed, Aug 13 2014 3:49 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | As the title says
Roy Lambert |
Tue, Sep 23 2014 6:59 AM | Permanent Link |
Adam Brett Orixa Systems | Roy
Do you use the "UNION ALL" statement? Or are you asking for something different from this? |
Wed, Sep 24 2014 5:04 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Adam
>Do you use the "UNION ALL" statement? >Or are you asking for something different from this? It works but if that's in the sql spec then the sql spec just gone down in my opinion (from a low starting point) My understanding of the difference between UNION and UNION ALL is that UNION eliminates duplicate rows and UNION ALL doesn't. Roy |
Wed, Oct 1 2014 5:19 AM | Permanent Link |
Adam Brett Orixa Systems | >>It works but if that's in the sql spec then the sql spec
>>just gone down in my opinion (from a low starting point) It does work & SQL Spec always seemed a mess to me too >>My understanding of the difference between UNION and >>UNION ALL is that UNION eliminates duplicate rows and >>UNION ALL doesn't. My introduction to using UNION ALL was specifically to allow addition of BLOB / CLOB ... so it came as a total shock to me when I was told that UNION eliminates duplicates! You are 100% right that it is a stupid mis-mash, using 1 term for 2 different processes. |
This web page was last updated on Thursday, March 28, 2024 at 08:36 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |