Posted by PYCTAM on 10/21/53 11:31

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?

best regards,
rustam bogubaev

• Next in forum: Re: Return Stored Procudure Values
• Prev in forum: Re: Interesting SQL query requirement for <SELECT> menu
• Thread view: grouping select query

[Reply to this message]