Posted by edouard.spooner on 11/02/06 11:46

Hi Razvan,

Thanks, but this wont work.

One of the responses will be

01 Jan 2006 | 09 Jan 2006 | 100 | 100 | 100

Ed

Razvan Socol wrote:
> It's a pretty simple query (much easier than doing it in VB):
>
> SELECT MIN(Date) as From, MAX(Date) as To,
> Price1, Price2, Price3
> FROM TheTable
> GROUP BY Price1, Price2, Price3
>
> Razvan
>
> edouard.spooner@gmail.com wrote:
> > Hi,
> >
> > I have a tricky SQL query problem that I'm having probs with.
> >
> > I have a table which resembles something like this
> >
> > Date | Price1 | Price2 | Price3
> > 01 Jan 2006 | 100 | 100 | 100
> > 02 Jan 2006 | 100 | 100 | 100
> > 03 Jan 2006 | 100 | 100 | 100
> > 04 Jan 2006 | 115 | 100 | 100
> > 05 Jan 2006 | 115 | 100 | 100
> > 06 Jan 2006 | 115 | 115 | 115
> > 07 Jan 2006 | 115 | 100 | 100
> > 08 Jan 2006 | 100 | 100 | 100
> > 09 Jan 2006 | 100 | 100 | 100
> >
> > and I want to write a query/view that will return this
> >
> > >From | To | Price1 | Price2 | Price3
> > 01 Jan 2006 | 03 Jan 2006 | 100 | 100 | 100
> > 04 Jan 2006 | 05 Jan 2006 | 115 | 100 | 100
> > 06 Jan 2006 | 06 Jan 2006 | 115 | 115 | 115
> > 07 Jan 2006 | 07 Jan 2006 | 115 | 100 | 100
> > 08 Jan 2006 | 09 Jan 2006 | 100 | 100 | 100
> >
> > Any ideas?
> >
> > I know how to write a routine that would do the same in VB but I am
> > looking to do a lot of the same calculation/query so I need it to be
> > fast (which VB wouldnt be)
> >
> > TIA
> >
> > Eddie

• Next in forum: Re: Tricky group by date problem
• Prev in forum: Re: Tricky group by date problem
• Thread view: Re: Tricky group by date problem

[Reply to this message]