Re: need help with a sql statement

From: Guido Konsolke <Guido.Konsolke_at_triaton.com>
Date: Tue, 21 Jan 2003 13:37:32 +0100
Message-ID: <1043152605.107548@news.thyssen.com>

"M. Gedecke" wrote...
> im kind of new to the sql / oracle business and i need help with an sql
> statement.
>
> i have table with 5 columns. 2 of them are important. in one of them is the
> date and in the other one is a value. i need to compare the date with its
> predate and calculate the difference between the two dates and find out
> those which exceed 5%.
> any help will be highly appreciated
>
> max

Hi Max,
sorry, but I don't understand exactly what you try to do. What is date, what is predate, what does 'exceed 5 %' mean? Could you please post your table structure with some example data? Maybe you can clarify your wish with this things.

Oh, and as usual in the Oracle related groups: please give us some infos about what OS (and version) and rdbms (and version) you use.

Greetings,
Guido Received on Tue Jan 21 2003 - 06:37:32 CST