5.check_groupby.mql 270 B

12345678910111213
  1. select count(*), max(v_double) as max_v_double, min(v_double), v_int, v_float from /test/basic2 group by v_int having v_float>1
  2. /**
  3. output()
  4. **/
  5. ;
  6. select count(*),max(v_double) as max_v_double, min(v_double), v_int from /test/basic group by v_int
  7. /**
  8. output()
  9. **/
  10. ;