42.aggr.mql 310 B

12345678910111213141516171819
  1. select count(*) from /test/foo where v_float>=2 group by v_text
  2. /**
  3. output()
  4. count(3)
  5. match(count,2)
  6. match(count,3)
  7. match(count,4)
  8. **/
  9. ;
  10. select v_text, count(id) from /test/foo where v_float>=2 group by v_text having count(*)>2
  11. /**
  12. output()
  13. count(2)
  14. match(v_text,'3',count,3)
  15. match(v_text,'4',count,4)
  16. **/
  17. ;