By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
1 rows affected
1 rows affected
1 rows affected
1 rows affected
1 rows affected
1 rows affected
1 rows affected
| SEN_NUM | SEN_NAME | SEN_BRAND | SEN_FUNC | NODE_ID |
|---|---|---|---|---|
| T01 | MA1 | MA2 | O3 | S001 |
| T02 | MB1 | MB2 | SO2 | S001 |
| T03 | MC1 | MA3 | NOX | S001 |
| T04 | MB1 | MC2 | SO2 | S002 |
| T05 | MC1 | MB2 | XOX | S002 |
| T06 | MC1 | MA2 | O3 | S002 |
| T06 | MC1 | MA2 | O3 | S002XXX |
| SEN_NUM | SEN_NAME | SEN_BRAND | SEN_FUNC |
|---|---|---|---|
| T01 | MA1 | MA2 | O3 |
| T02 | MB1 | MB2 | SO2 |
| T03 | MC1 | MA3 | NOX |
| T04 | MB1 | MC2 | SO2 |
| T05 | MC1 | MB2 | XOX |
| T06 | MC1 | MA2 | O3 |
| SEN_NUM | SEN_NAME | SEN_BRAND | SEN_FUNC |
|---|---|---|---|
| T01 | MA1 | MA2 | O3 |
| T02 | MB1 | MB2 | SO2 |
| T03 | MC1 | MA3 | NOX |
| T04 | MB1 | MC2 | SO2 |
| T05 | MC1 | MB2 | XOX |
| T06 | MC1 | MA2 | O3 |