group_by_ru_join.sql 205 B

12345
  1. /* syntax version 1 */
  2. /* postgres can not */
  3. pragma sampleselect;
  4. 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;