Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Distinct not working when convert DATE using TO_CHAR
"SunScreen" <alampro_at_yahoo.com> wrote in message
news:1135092970.325977.267660_at_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.
>
still no sample data
still guessing what the problem is...
in SQL, DISTINCT applies to the entire select list (as mentioned before). are you expecting it to apply to only the first field in your select list?
are the rows in the resultset distinct? then its working, and you're expecting the wrong results/effect
++ mcs Received on Tue Dec 20 2005 - 09:49:19 CST