Posted by Robert Klemme on 10/21/30 11:31

PYCTAM wrote:
> Hi,
>
> I have data stored as in below sample :
>
> -------------------------------+---------------------------------+------
--------
> DateBegin | DateEnd | Rate
> -------------------------------+---------------------------------+------
--------
> 2005-11-13 00:00:00 2005-11-14 00:00:00 63.0000
> 2005-11-14 00:00:00 2005-11-15 00:00:00 63.0000
> 2005-11-15 00:00:00 2005-11-16 00:00:00 45.0000
> 2005-11-16 00:00:00 2005-11-17 00:00:00 45.0000
> 2005-11-17 00:00:00 2005-11-18 00:00:00 45.0000
> 2005-11-18 00:00:00 2005-11-19 00:00:00 45.0000
> 2005-11-19 00:00:00 2005-11-20 00:00:00 45.0000
> 2005-11-20 00:00:00 2005-11-21 00:00:00 63.0000
> 2005-11-21 00:00:00 2005-11-22 00:00:00 63.0000
> -------------------------------+---------------------------------+------
--------
>
>
> I have to group the select query in this way :
>
> -------------------------------+---------------------------------+------
--------
> DateBegin | DateEnd | Rate
> -------------------------------+---------------------------------+------
--------
> 2005-11-13 00:00:00 2005-11-15 00:00:00 63.0000
> 2005-11-15 00:00:00 2005-11-20 00:00:00 45.0000
> 2005-11-20 00:00:00 2005-11-22 00:00:00 63.0000
> -------------------------------+---------------------------------+------
--------
>
> When I run below grouped statement, I get follewed result:
>
> SELECT MIN(DateBegin) AS DateBegin, MAX(DateEnd) AS DateEnd,
> Rate FROM X GROUP BY Rate
>
> -------------------------------+---------------------------------+------
--------
> DateBegin | DateEnd | Rate
> -------------------------------+---------------------------------+------
--------
> 2005-11-13 00:00:00 2005-11-22 00:00:00 63.0000
> 2005-11-15 00:00:00 2005-11-20 00:00:00 45.0000
> -------------------------------+---------------------------------+------
--------
>
> How can I do a query like in 2nd sample from top?

Care to explain by what you want to group? I cannot recognize it from
your sample output.

robert

• Next in forum: stored procedure update HUGE PROBLEM
• Prev in forum: Re: Return Stored Procudure Values
• Thread view: Re: grouping select query

[Reply to this message]