Re: distinct

Andrea wrote:

> Hi,
>
> I have the following SQL
>
> "SELECT TRUNC(datetime) FROM table1 WHERE object_nr=1 AND datetime BETWEEN
> ('01.01.2004') AND ('18.03.2004') AND value BETWEEN 1.5 AND 7.5 ORDER BY
> datetime"
>
> I am getting multiple rows for the same date. Using of "SELECT DISTINCT
> TRUNC(...." I get
> ORA-01791.
> Any solutions to this problem?
>
> Regards
> Andrea

Take Niall's advice but also do this:

SELECT keyword
FROM v$reserved_word
WHERE keyword = 'VALUE';

Looks like a remarkably bad choice for a column name.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)