Postgres Pro
Downloads
Home   >   mailing lists

Re: Electricity bill - Mailing list pgsql-sql

From David G. Johnston
Subject Re: Electricity bill
Date
Msg-id CAKFQuwaY-zeoWkJwqDP6TDZnowdif2AZsT28+-SA2OWc8KXKTA@mail.gmail.com
Whole thread Raw
In response to Electricity bill  ("Theodore M Rolle, Jr." <stercor@gmail.com>)
Responses Re: Electricity bill
List pgsql-sql
Tree view
On Tue, Jun 7, 2022 at 6:39 PM Theodore M Rolle, Jr. <stercor@gmail.com> wrote:
I'm putting in YYYY-MM-DD dates of electricity bills and would like to not have starting and ending dates in the same row. Only ending date.
Will someone show me the SQL to compute the months’ usage? This requires retrieving two rows to compute the number of days...

You can use a window function called lead (or lag) to retrieve a value from the next (previous) row and associate it with the current row.

David J.

pgsql-sql by date:

Previous
From: Jonathan Katz
Date:
Subject: Re: Electricity bill
Next
From: "Theodore M Rolle, Jr."
Date:
Subject: Fwd: Electricity bill