table_funcs_group_by.sql 207 B

1234567891011
  1. /* syntax version 1 */
  2. /* postgres can not */
  3. use plato;
  4. --insert into Output
  5. select
  6. groupTribit,
  7. count(*) as count
  8. from Input
  9. GROUP BY TableRecordIndex() % 3 as groupTribit
  10. ORDER BY groupTribit, count