ObjectDB ObjectDB

Internal Website Search

1-10 of 17 resultsRefresh
120

avg(x)

Method javax.persistence.criteria.CriteriaBuilder Expression<Double> avg( Expression<N> x ) Create an aggregate expression applying the avg operation. Parameters: x - expression representing input value to avg operation Returns: avg expression Since: JPA 2.0
83

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 ... language: SELECT SUM(c.population), AVG(c.population) FROM Country c WHERE 'English' MEMBER OF c
24

FROM clause (JPQL / Criteria API)

reserved words: ABS, ALL, AND, ANY, AS, ASC, AVG, BETWEEN, BIT_LENGTH, BOTH, BY, CASE, CHAR_LENGTH
24

ObjectDB Object Database Features

and aggregates). ORDER BY (including ASC, DESC). Aggregates (COUNT, SUM, AVG, MAX, MIN). Query
24

CRUD Database Operations with JPA

see another example of a query that returns a single result: Query q2 = em.createQuery("SELECT AVG(p.x) FROM
24

Is ObjectDB better than competing object databases?

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

JPA Criteria API Queries

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

JPA Query Structure (JPQL / Criteria)

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

Step 3: Add a Main Class

.createQuery("SELECT AVG(p.x) FROM Point p"); System.out.println("Average X: " + q2.getSingleResult
4

Step 3: Add a Main Class

()); // Find the average X value: Query q2 = em.createQuery("SELECT AVG(p.x) FROM Point

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