124 | min(x)Method javax.persistence.criteria.CriteriaBuilder Expression<N> min( Expression<N> x ) Create an aggregate expression applying the numerical min operation. Parameters: x - expression representing input value to min operation Returns: min expression Since: JPA 2.0 |
53 | Comparison in JPQL and Criteria API that can replace two simple comparisons. The two following expressions are equivalent (:min and :max are query parameters): x BETWEEN :min AND :max x >= :min AND x <= :max Similarly, NOT BETWEEN is also a shortcut and the following expressions are equivalent: x NOT BETWEEN :min AND :max x < :min OR x |
41 | Index Definition and for projection: SELECT MIN(p.x) FROM Point p WHERE p.x < p.y ORDER BY p.y In the above example ... of the scan) thus eliminating the need for a separate sort. Finally, indexes are also used in MIN and MAX queries: SELECT MIN(p.x), MAX(p.x) FROM Point p Given an index on field x ObjectDB |
41 | GROUP BY and HAVING clauses calculations (count, sum, avg, max, min) that are carried out on all the objects (or the object tuples) in ... of numeric values. AVG - returns the average of numeric values as a double value. MIN - returns ... of numeric values. min, least - return an expression representing the minimum of comparable values. max |
23 | FROM clause (JPQL / Criteria API), INDEX, INNER, IS, JOIN, KEY, LEADING, LEFT, LENGTH, LIKE,LOCATE, LOWER, MAX, MEMBER, MIN, MOD, NEW |
23 | Is ObjectDB better than competing object databases? queries (max, min, count, sum and avg). ObjectDB supports rich queries, including aggregate queries |
23 | JPA Query Structure (JPQL / Criteria) GROUP BY / HAVING (groupBy, having, count, sum, avg, min, max, ...). Criteria ORDER BY (orderBy, Order, asc, desc). |
23 | ObjectDB Object Database Features (COUNT, SUM, AVG, MAX, MIN). Query Expressions Path navigation expressions using the dot (.) operator |
23 | JPA Criteria API Queries, count, sum, avg, min, max, ...). ORDER BY clause (orderBy, Order, asc, desc). The links |
16 | javax.persistence.criteria.CriteriaBuilder expression Since: JPA 2.0 Expression<N> min( Expression<N> x) Create an aggregate expression applying the numerical min operation. Create an aggregate expression applying the numerical min operation. Parameters: x - expression representing input value to min operation Returns: min expression |
