add batch remove batch split batch comment selection show hidden batches hide batch highlight batch
db<>fiddle
donate feedback about
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
Help with an interesting Postgres question: Why isn't an Index Only Scan used on a partition accessed via the parent table?.
12 rows affected
p q r
1 A
2 A
3 D
4 C
5 X
6 A
7 D
8 C
9 X
10 D null
11 C
12 C
4 rows affected
s t
A
D
C
X
部門 等級 人員 數量 百分比
A 2  40%
D 2  40%
X 1  20%
C 3  75%
X 1  25%
A 1  50%
C 1  50%