blob: 462b2777a0257ceee577e85553eba7760fa61a3b (
plain) (
blame)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
|
USE plato;
PRAGMA DisableSimpleColumns;
--INSERT INTO Output
SELECT
hundred_keys, sum(cast(data.subkey as uint32)) -- should use backticks or brackets
FROM (
SELECT data.key as dkey, data.*
FROM Input as data
) as middle
GROUP BY
cast(middle.dkey as uint32)/100 as hundred_keys
ORDER BY hundred_keys
|
