By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
7 rows affected
AccountNumber | MeterNumber | StartDate | EndDate | RateCode | RowNumber |
---|---|---|---|---|---|
0142628117 | 123470203 | 2020-04-22 | 9999-12-31 | UGE-PECO-E-R-V-GRN-HOLDOVER-ETF0_APR20 | 1 |
0142628117 | 123470203 | 2019-04-10 | 2020-04-09 | ***Custom*** | 2 |
0142628117 | 123470205 | 2020-04-22 | 9999-12-31 | UGE-PECO-E-R-V-GRN-HOLDOVER-ETF0_APR20 | 1 |
0142628117 | 123470205 | 2019-04-10 | 2020-04-09 | ***Custom*** | 2 |
0500000178767001363445 | TCA105238304 | 2018-10-02 | 2019-08-11 | ***Custom*** | 1 |
0500000178767001363445 | TCA105238304 | 2016-02-25 | 2016-04-22 | ***Custom*** | 2 |
0500000178767001363445 | TCA130359929 | 2019-08-12 | 9999-12-31 | ***Custom*** | 1 |
AccountNumber | MeterNumber | StartDate | EndDate | RateCode | RowNumber | EndDateRateCount |
---|---|---|---|---|---|---|
0142628117 | 123470203 | 2020-04-22 | 9999-12-31 | UGE-PECO-E-R-V-GRN-HOLDOVER-ETF0_APR20 | 1 | 1 |
0142628117 | 123470205 | 2020-04-22 | 9999-12-31 | UGE-PECO-E-R-V-GRN-HOLDOVER-ETF0_APR20 | 1 | 1 |
0500000178767001363445 | TCA130359929 | 2019-08-12 | 9999-12-31 | ***Custom*** | 1 | 2 |
0500000178767001363445 | TCA105238304 | 2018-10-02 | 2019-08-11 | ***Custom*** | 1 | 2 |
AccountNumber | MeterNumber | StartDate | EndDate | RateCode |
---|---|---|---|---|
0500000178767001363445 | TCA130359929 | 2019-08-12 | 9999-12-31 | ***Custom*** |
0500000178767001363445 | TCA105238304 | 2018-10-02 | 2019-08-11 | ***Custom*** |