YQL_20895_having_depth_2.sql « pg « suites « sql « tests « essentials « yql - ydb - Mirror of YDB github repos

summary refs log tree commit diff stats

path: root/yql/essentials/tests/sql/suites/pg/YQL_20895_having_depth_2.sql

blob: 18719e6bfbc619a7dac2e7b24a1a9ab708300380 (plain) (blame)

--!syntax_pg

SELECT x
FROM (VALUES (1)) AS t(x) GROUP BY x
HAVING (Count(*) / (SELECT Count(*) FROM (VALUES ('1')) AS t(x))) = 1;