Re: Max Query Issue
JOHN FARRUGIA wrote:
> even if I use this query:
> SELECT MAX(value) FROM data_readings.lts4a_line the result is still no the max in the column
Is your value column a string type? If so, sorting will be alphabetically and incorrect.
> what does s1 and s2 represent
Table aliases.
--
felix
Please use
BBCode to format your messages in this forum.
Subject
Written By
Posted
Re: Max Query Issue
May 20, 2005 02:19PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.