By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
12 rows affected
| 第幾組 | 階層 | 主件 | 元件 |
|---|---|---|---|
| 1 | |1| | A | B |
| 1 | | |2| | B | E |
| 1 | | |2| | B | F |
| 1 | | |2| | B | G |
| 1 | |1| | A | C |
| 1 | |1| | A | D |
| 2 | |1| | A1 | B1 |
| 2 | | |2| | B1 | E1 |
| 2 | | |2| | B1 | F1 |
| 2 | | |2| | B1 | G1 |
| 2 | |1| | A1 | C1 |
| 2 | |1| | A1 | D1 |
| 3 | |1| | B | E |
| 3 | |1| | B | F |
| 3 | |1| | B | G |
| 4 | |1| | B1 | E1 |
| 4 | |1| | B1 | F1 |
| 4 | |1| | B1 | G1 |