On 2-5-2015 10:50, [email protected] [firebird-support] wrote: > 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?
By what logic do you arrive at this result? Mark -- Mark Rotteveel
