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

2015-05-02 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
On 2-5-2015 10:50, brucedickin...@wp.pl [firebird-support] wrote: I am having such data: ID DATE_TIMETYPE 101.01.2015, 00:00:00.000A 201.01.2015, 00:01:00.000A 301.01.2015, 00:02:00.000A 401.01.2015, 00:10:00.000B 501.01.2015,

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

2015-05-02 Thread brucedickin...@wp.pl [firebird-support]
Hi guys. I am having such data: ID DATE_TIMETYPE 101.01.2015, 00:00:00.000A 201.01.2015, 00:01:00.000A 301.01.2015, 00:02:00.000A 401.01.2015, 00:10:00.000B 501.01.2015, 00:15:00.000B 601.01.2015, 00:20:00.000A 7

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

2015-05-02 Thread Svein Erling Tysvær svein.erling.tysv...@kreftregisteret.no [firebird-support]
Hi guys. Hi Bruce! I am having such data: ID DATE_TIMETYPE 101.01.2015, 00:00:00.000A 201.01.2015, 00:01:00.000A 301.01.2015, 00:02:00.000A 401.01.2015, 00:10:00.000B 501.01.2015, 00:15:00.000B 601.01.2015, 00:20:00.000A 7