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?.
CREATE TABLE
CREATE TABLE
INSERT 0 10
INSERT 0 10
id val rank
10 106 1
9 96 2
8 86 3
7 76 4
6 66 5
5 56 6
4 46 7
3 36 8
2 26 9
1 16 10
SELECT 10
排骨組val 在雞腿組排名
104 2
94 3
84 4
74 5
64 6
54 7
44 8
34 9
24 10
14 11
SELECT 10