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.
dt goods price
2020-09-01 metal 10.00
2020-09-01 plastics 2.20
2020-09-01 paper 5.10
2020-09-02 metal 12.20
2020-09-02 plastics 3.10
2020-09-02 paper 5.20
2020-09-03 metal 16.30
2020-09-03 plastics 2.90
2020-09-03 paper 7.10
dt goods price rank TempValue variance
2020-09-01 metal 10.00 1 1.000 1
2020-09-02 metal 12.20 2 6.100 6.1
2020-09-03 metal 16.30 3 8.150 49.715
2020-09-01 paper 5.10 1 1.000 1
2020-09-02 paper 5.20 2 2.600 2.6
2020-09-03 paper 7.10 3 3.550 9.23
2020-09-01 plastics 2.20 1 1.000 1
2020-09-02 plastics 3.10 2 1.550 1.55
2020-09-03 plastics 2.90 3 1.450 2.2475