Home » Search

About COUNT

11-20 of 120Refresh
Manual
13

FROM clause (JPQL / Criteria API)

_LENGTH, CHARACTER_LENGTH, CLASS, COALESCE, CONCAT, COUNT, CURRENT_DATE, CURRENT_TIME, CURRENT
FAQ
13

Is ObjectDB better than competing object databases?

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

JPA Criteria API Queries

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

JPA Query Structure (JPQL / Criteria)

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

Numbers in JPQL and Criteria Queries

Numeric values may appear in JPQL queries in many forms: as numeric literals - e.g. 123, -12.5. as parameters - when numeric values are assigned as arguments. as path expressions - in navigation to persistent numeric fields. as aggregate expressions - e.g. COUNT. as collection functions
Manual
13

ORDER BY clause (JPQL / Criteria API)

WHERE 'Europe' MEMBER OF c.continents GROUP BY c.currency HAVING COUNT(c) > 1 ORDER BY c.currency
Tutorial
13

Step 3: Add a Main Class

(); // Find the number of Point objects in the database: Query q1 = em.createQuery("SELECT COUNT(p
Tutorial
13

Step 3: Add a Main Class

: Query q1 = em.createQuery("SELECT COUNT(p) FROM Point p"); System.out.println("Total
Manual
13

Strings in JPQL and Criteria Queries

. LENGTH - Counting Characters in a String The LENGTH(str) function returns the number of characters in
Result
13

ObjectDB Object Database Features

). GROUP BY (including HAVING and aggregates). ORDER BY (including ASC, DESC). Aggregates (COUNT, SUM