yql/essentials/tests/sql/suites/aggregate/group_by_ru_join.sql


1
2
3
4
5

/* syntax version 1 */
/* postgres can not */

pragma sampleselect;
select * FROM plato.Input AS t1 INNER JOIN plato.Input AS t2 USING (key) GROUP BY ROLLUP(t1.key as kk, t1.subkey as sk) ORDER BY kk, sk;