The difference could be in the time, so try and display it.

Regards Kevin B.

PRIVILEGED, PRIVATE AND CONFIDENTIAL
=======================================================
The information contained in this electronic message e-mail, and
any files transmitted with it, is intended for the named recipient(s)
only. If you are not the intended recipient, you must not copy,
distribute or take any action in reliance on it, please delete it
immediately and notify me of the error by reply e-mail. I do not
represent, warrant or guarantee that the integrity of this
communication has been maintained nor that the communication
is free of errors, virus or interference.
=======================================================
Kevin Biasi
Software Engineer
Dimension Data
Telephone - 61 3 9626-0379
E-ddress - kevin.[Email address protected]




" \(Frank Dodgers\)"
<oracledba-ezmlmshield-x17191326.[Email address protected]
30/11/2004 05:33 AM


To: "LazyDBA Discussion" <[Email address protected]
cc:
Subject: select distinct question


Anyone know why this select distinct returns multiple rows with the same
value? Thanks so much! (the "-" is actually an "@" for a dblink.

SQL> select distinct CLAIM_DRIVER_STEPS.DATE_CREATED from
CLAIM_DRIVER_STEPS
where DATE_CREATED not in (select DATE_CREATED from
CLAIM_DRIVER_STEPS-cpedev);

DATE_CREA
---------
23-SEP-04
23-SEP-04

2 rows selected.

--
Thank You,
Frank Dodgers
Oracle & DB2 Certified
Evergreen Information Systems
-303-674-0433 Home
-303-810-6625 Cell
frank.[Email address protected]


--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these terms:http://www.lazydba.com/legal.html




Oracle LazyDBA home page