By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
1 rows affected
PID | SALYR | CNT | SAL_PREV | SAL_DIFF | PERC |
---|---|---|---|---|---|
1 | 2019 | 3 | 0 | 3 | 0 |
1 | 2020 | 1 | 3 | -2 | -66.67 |
2 | 2018 | 2 | 0 | 2 | 0 |
2 | 2020 | 1 | 2 | -1 | -50 |
1 rows affected
PID | SALYR | CNT | SAL_PREV | SAL_DIFF | PERC |
---|---|---|---|---|---|
1 | 2019 | 3 | 0 | 3 | 0 |
1 | 2020 | 1 | 3 | -2 | -66.67 |
2 | 2018 | 2 | 0 | 2 | 0 |
2 | 2020 | 1 | 2 | -1 | -50 |