TopFreq.sql 200 B

1234567891011121314
  1. /* syntax version 1 */
  2. USE plato;
  3. SELECT
  4. key, TopFreq(value, 3, 5u)
  5. FROM
  6. (SELECT
  7. key as value,
  8. "" as subkey,
  9. cast (value as Uint32) as key
  10. FROM Input)
  11. AS tmp
  12. GROUP BY key
  13. ORDER BY key