Re: DISTINCT in UNION

Hello,

Have you check for things like trailing spaces? Maybe the values are different in this table, but you see them as same, that is my point. Other example could be with dates. You can see all "same" values in the output, if your session is set to display dates as 'MM/DD/YY', however, they are actually all different.

What kind of column INVEST_SEQ_NBR is?

And what tool do you use to access the database?

shaikh74_at_my-deja.com wrote:

> 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.
Received on Thu Nov 09 2000 - 16:24:14 CST