Oracle FAQ

Your Portal to the Oracle Knowledge Grid

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US

Home -> Community -> Usenet -> c.d.o.misc -> Re: Distinct not working when convert DATE using TO_CHAR

Re: Distinct not working when convert DATE using TO_CHAR

From: SunScreen <alampro_at_yahoo.com>
Date: 20 Dec 2005 07:36:10 -0800
Message-ID: <1135092970.325977.267660@g47g2000cwa.googlegroups.com>

The problem is that DISTINCT applies to Field1, with duplicate values. In the first query everything is ok, In the second query results have duplicate values for Field1. Received on Tue Dec 20 2005 - 09:36:10 CST

This message: [ Message body ]
Next message: Jimbo1: "Re: How to find the Overall cost of a query?"
Previous message: Mike Reed: "Re: owa_pattern.pattern as a type"
In reply to: Mark C. Stock: "Re: Distinct not working when convert DATE using TO_CHAR"
Next in thread: Mark C. Stock: "Re: Distinct not working when convert DATE using TO_CHAR"
Reply: Mark C. Stock: "Re: Distinct not working when convert DATE using TO_CHAR"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US