By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
Records: 7 Duplicates: 0 Warnings: 0
| loc_code | user_id | service_area | service_sector | service | status | last_changed |
|---|---|---|---|---|---|---|
| 101 | 1001 | C | 1 | PAINT | INACTIVE | 2020-11-28 |
| 101 | 1002 | A | 1 | WOOD | INACTIVE | 2020-12-07 |
| 101 | 1002 | A | 1 | CLEANING | ACTIVE | 2020-11-23 |
| 101 | 1002 | A | 1 | PEST | INACTIVE | 2020-12-07 |
| 101 | 1002 | A | 2 | LIGHT | INACTIVE | 2020-12-07 |
| 101 | 1002 | B | 2 | AC | INACTIVE | 2020-11-28 |
| 101 | 1002 | B | 2 | HEATER | INACTIVE | 2020-11-30 |
| loc_code | user_id | service_area | service_sector | service | status | last_changed | only_inactive | rn |
|---|---|---|---|---|---|---|---|---|
| 101 | 1001 | C | 1 | PAINT | INACTIVE | 2020-11-28 | 1 | 1 |
| 101 | 1002 | A | 2 | LIGHT | INACTIVE | 2020-12-07 | 1 | 1 |
| 101 | 1002 | B | 2 | HEATER | INACTIVE | 2020-11-30 | 1 | 1 |