About MIN

1-10 of 20Refresh
JPA Doc
107

min(x)

Method javax.persistence.criteria.CriteriaBuilder Expression min(   Expression 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
Manual
41

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
Manual
32

GROUP BY and HAVING clauses

(count, sum, avg, max, min) that are carried out on all the objects (or the object tuples) in the group ... of numeric values. AVG - returns the average of numeric values as a double value. MIN - returns the minimum ... of numeric values. min, least - return an expression representing the minimum of comparable values. max
Manual
32

Index Definition

MIN(p.x) FROM Point p WHERE p.x < p.y ORDER BY p.y In the above example, a composite index ... ) 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 can simply return the first and last key in the BTree, without any iteration.
Manual
18

FROM clause (JPQL / Criteria API)

, IN, INDEX, INNER, IS, JOIN, KEY, LEADING, LEFT, LENGTH, LIKE,LOCATE, LOWER, MAX, MEMBER, MIN, MOD
Manual
18

JPA Criteria API Queries

, having, count, sum, avg, min, max, ...). ORDER BY clause (orderBy, Order, asc, desc). The links
FAQ
18

Is ObjectDB better than competing object databases?

queries (max, min, count, sum and avg). ObjectDB supports rich queries, including aggregate queries
Manual
18

JPA Query Structure (JPQL / Criteria)

GROUP BY / HAVING (groupBy, having, count, sum, avg, min, max, ...). Criteria ORDER BY (orderBy, Order, asc, desc).
Result
18

ObjectDB Object Database Features [2018-01-27]

, AVG, MAX, MIN). Query Expressions Path navigation expressions using the dot (.) operator. Comparison
Result
18

ObjectDB Object Database Features [2018-10-27]

, AVG, MAX, MIN). Query Expressions Path navigation expressions using the dot (.) operator. Comparison