Guest User

Untitled

a guest
Jan 19th, 2019
92
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.93 KB | None | 0 0
  1. $sql->select()
  2. ->columns(array('GroupedColum'
  3. ,'minValue' => new Expression('min(ValueColumn)')))
  4. ->from('ValueTable')
  5. ->group('GroupedColum')
  6. ->order('minValue')
  7. ->order('GroupedColum')
  8. ->limit(10);
  9.  
  10. $predicate = new ZendDbSqlPredicatePredicate();
  11. $sql->where($predicate->greaterThan('filterColumn','20);
  12.  
  13. select GroupedColum
  14. , min(ValueColumn) as minValue
  15. from ValueTable
  16. where filterColumn > 20
  17. group by GroupedColum
  18. order by minValue
  19. GroupedColum
  20. limit 10;
  21.  
  22. $predicate = new ZendDbSqlPredicatePredicate();
  23.  
  24. $predicate = new ZendDbSqlWhere();
  25.  
  26. $sql->select()
  27. ->columns(array('GroupedColum'
  28. ,'minValue' => new Expression('min(ValueColumn)')))
  29. ->from('ValueTable')
  30. ->group('GroupedColum')
  31. ->order('minValue')
  32. ->order('GroupedColum')
  33. ->limit(10);
  34. $predicate = new ZendDbSqlWhere();
  35. $sql->where($predicate->greaterThan('filterColumn','20);
Add Comment
Please, Sign In to add comment