dedup_state_keys.sql « aggregate « suites « sql « tests « essentials « yql - ydb - Mirror of YDB github repos

about summary refs log tree commit diff stats

path: root/yql/essentials/tests/sql/suites/aggregate/dedup_state_keys.sql

blob: 9adbc0dad1521f4c653942e114021490039d3f2a (plain) (blame)

USE plato;
SELECT
    key,
    value,
    count(*) AS c
FROM Input
GROUP BY
    key,
    value
ORDER BY c, key, value;