distinct_over_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/distinct_over_keys.sql

blob: c74e5e2f3c35120ce43ae6cc4d72e3705d24a8bb (plain) (blame)

pragma DistinctOverKeys;
SELECT x, count(distinct x) AS cnt
FROM (values (1),(1)) as a(x) GROUP BY x