119 | 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 |
73 | 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 |
50 | 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 |
39 | 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 |
22 | , INDEX, INNER, IS, JOIN, KEY, LEADING, LEFT, LENGTH, LIKE,LOCATE, LOWER, MAX, MEMBER, MIN, MOD, NEW |
22 | (COUNT, SUM, AVG, MAX, MIN). Query Expressions Path navigation expressions using the dot (.) operator |
22 | queries (max, min, count, sum and avg). ObjectDB supports rich queries, including aggregate queries |
22 | , count, sum, avg, min, max, ...). ORDER BY clause (orderBy, Order, asc, desc). The links |
22 | GROUP BY / HAVING (groupBy, having, count, sum, avg, min, max, ...). Criteria ORDER BY (orderBy, Order, asc, desc). |
15 | 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 |