select_having.sql « pg « 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/pg/select_having.sql

blob: faba1d41f91b220b80683e371fd24d44ba47e68b (plain) (blame)

--!syntax_pg
select x,sum(y)
from (values (1,2),(3,4),(3,5)) u(x,y)
group by x
having count(y)=2