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

INSERT 0 10
date salesman amount
2020-01-01 john 10
2020-01-02 john 15
2020-01-03 john 8
2020-01-04 john 12
2020-01-05 john 11
2020-01-01 daniel 5
2020-01-02 daniel 6
2020-01-03 daniel 7
2020-01-04 daniel 8
2020-01-05 daniel 9 
SELECT 10
date salesman amount sum
2020-01-01 daniel 5 5
2020-01-02 daniel 6 11
2020-01-03 daniel 7 18
2020-01-04 daniel 8 21
2020-01-05 daniel 9 24
2020-01-01 john 10 10
2020-01-02 john 15 25
2020-01-03 john 8 33
2020-01-04 john 12 35
2020-01-05 john 11 31 
SELECT 10
date salesman amount sum
2020-01-01 daniel 5 5
2020-01-02 daniel 6 11
2020-01-03 daniel 7 18
2020-01-04 daniel 8 21
2020-01-05 daniel 9 24
2020-01-01 john 10 10
2020-01-02 john 15 25
2020-01-03 john 8 33
2020-01-04 john 12 35
2020-01-05 john 11 31 
SELECT 10