Re: DISTINCT in UNION

If this is really happening, it's a bug.

UNION does a SORT (UNIQUE)
prior to output.

As an alternative - are you sure that the numbers ARE duplicated, is it possible
that a 3GL has caused differences at
(say) the 36th sig. fig. that are not
appearing in the default output ?

--

Jonathan Lewis
Yet another Oracle-related web site:  http://www.jlcomp.demon.co.uk

Practical Oracle 8i:  Building Efficient Databases

Publishers:                 Addison Wesley Longman
Book bound date:     8th Dec 2000
See a first review at:
http://www.ixora.com.au/resources/index.htm#practical_8i

shaikh74_at_my-deja.com wrote in message <8uems6$3ra$1_at_nnrp1.deja.com>...


>Hello Deja community:

>Here is something to challenge your mind,

>

>SELECT DISTINCT INV.INVEST_SEQ_NBR,

>FROM   INVESTIGATION INV

>UNION

>SELECT DISTINCT INV.INVEST_SEQ_NBR,

>FROM   INVESTIGATION INV

>

>I am getting duplicate rows back with same INV.INVEST_SEQ_NBR.  I was

>wondering how can I apply DISTINCT on the result set returned by

>UNION.  As you can see, in above query DISTINCT is appllied to each

>query but on the final result set.  Your assitance is appreiciated.

>Send reply to shaikh74_at_visto.com

>Thanks

>Asad

>

>

>Sent via Deja.com http://www.deja.com/

>Before you buy.