Home » Search

About COUNT

11-20 of 120Refresh
Manual
12

FROM clause (JPQL / Criteria API)

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

Is ObjectDB better than competing object databases?

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

JPA Criteria API Queries

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

JPA Query Structure (JPQL / Criteria)

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

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
12

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
12

Step 3: Add a Main Class

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

Step 3: Add a Main Class

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

Strings in JPQL and Criteria Queries

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

ObjectDB Object Database Features

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