[firebird-support] Is it possible to do this with window function?

Sat, 02 May 2015 01:51:08 -0700 

Hi guys.

I am having such data:

ID   DATE_TIME                    TYPE  
1    01.01.2015, 00:00:00.000    A
2    01.01.2015, 00:01:00.000    A
3    01.01.2015, 00:02:00.000    A
4    01.01.2015, 00:10:00.000    B
5    01.01.2015, 00:15:00.000    B
6    01.01.2015, 00:20:00.000    A
7    01.01.2015, 00:25:00.000    A

 Is it possible to write query which will result:
 
TYPE  DATE_MIN                       DATE_MAX  
    A    01.01.2015, 00:00:00.000  01.01.2015, 00:02:00.000
     B    01.01.2015, 00:10:00.000  01.01.2015, 00:15:00.000 

     A    01.01.2015, 00:20:00.000  01.01.2015, 00:25:00.000

As you can see I would like to have three groups and not two like it would have 
been with usage of standard GROUP BY. I know I can write a selectable stored 
procedure which will result me such data but is it possible to do with new 
window functions and partitioning?

Thanks.

Reply via email to