ObjectDB ObjectDB

Internal Website Search

1-10 of 22 resultsRefresh
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

Getting Started

ObjectDB is very easy to use. Follow the Getting Started Tutorial and the Quick Tour manual chapter and in minutes you may be able to write and run first Java programs against ObjectDB.

Prior knowledge or experience in database programming (SQL, JDBC, ORM, JPA, etc.) is not required, but some background in using the Java language is essential.

Need Help?

  1. Search ObjectDB website
  2. Read the FAQ
  3. Follow the Tutorials
  4. View or post in the forum
  5. Search or file an issue
  6. Contact support