On Tue, Jun 7, 2022 at 6:39 PM Theodore M Rolle, Jr. <stercor(at)gmail(dot)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.