Home » Search

About MIN

1-10 of 18Refresh
JPA Doc
116

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
94

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
49

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
38

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
22

FROM clause (JPQL / Criteria API)

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

Is ObjectDB better than competing object databases?

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

JPA Criteria API Queries

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

JPA Query Structure (JPQL / Criteria)

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

ObjectDB Object Database Features

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

javax.persistence.criteria.CriteriaBuilder

expression Since: JPA 2.0 Expression min( Expression 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