Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Complex SELECT problem
> >
> > SELECT article, price, decode(on_stock, 'Y', 'Yes', 'N', 'No')
> > WHERE purchase_date BETWEEN %start and end date%
> > ORDER BY article
> >
> > Pawel Dulak
>
> Yes but not with your code. Where did you get the following:
> WHERE purchase_date BETWEEN %start and end date%?
>
> This should be written as:
>
> WHERE purchase_date BETWEEN start_date AND end_date;
>
> and you need to provide the values of start_date and end_date
> date variables.
OH, i know, i know, but it is not ESSENCE of my problem. The problem is: how to get list of articles, prices and sub sum of prices after each article in single query.
Please don't focus on inessentials. :)
Thx
Pawel Dulak Received on Tue Mar 09 2004 - 03:02:38 CST