Home Explore Help
Sign In
SMusatov
/
ydb
mirror of https://github.com/ydb-platform/ydb.git
1
0
Fork 0
Files
Tree: 686cf76645
Branches Tags
ydb
/
yql
/
essentials
/
tests
/
sql
/
suites
/
pg
/
select_having_same_agg.sql

select_having_same_agg.sql 99 B
History Raw

12345 
  1. --!syntax_pg
    2. 

  2. select x,count(y)
    3. 

  3. from (values (1,2),(3,4),(3,5)) u(x,y)
    4. 

  4. group by x
    5. 

  5. having count(y)=2
    6.