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


1
2
3
4
5
6
7
8
9
10
11

/* syntax version 1 */
/* postgres can not */
use plato;

--insert into Output
select
  groupTribit,
  count(*) as count
from Input
GROUP BY TableRecordIndex() % 3 as groupTribit
ORDER BY groupTribit, count