Tuesday, 29 March 2016

RE: [firebird-support] How to add previous column value to current value?

 

let's assume that I have 2.5.3

Pozdrawiam

Piotr Olszewski

-----Original Message-----
From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com]
Sent: Tuesday, March 29, 2016 11:45 AM
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] How to add previous column value to current
value?

29.03.2016 11:40, 'Piotr Olszewski' piotr.olszewski@eskrzynka.pl
[firebird-support] wrote:
> I need to get a date difference (days between) between rows.

With Firebird 3.0 you can use window function LAG.

--
WBR, SD.

------------------------------------

------------------------------------

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Visit http://www.firebirdsql.org and click the Documentation item on the
main (top) menu. Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at
http://www.ibphoenix.com/resources/documents/

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
------------------------------------

Yahoo Groups Links

__._,_.___

Posted by: "Piotr Olszewski" <piotr.olszewski@eskrzynka.pl>
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (3)
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

.

__,_._,___

No comments:

Post a Comment