Home » Search

About GROUP BY

1-10 of 200Refresh
Manual
387

GROUP BY and HAVING clauses

The GROUP BY clause enables grouping of query results. A JPQL query with a GROUP BY clause returns properties of generated groups instead of individual objects and fields. The position of a GROUP BY ... clause. When a GROUP BY clause exists in a JPQL query, database objects (or tuples of database objects
Manual
170

ORDER BY clause (JPQL / Criteria API)

expression: SELECT c.name FROM Country c ORDER BY c.name DESC Grouping (GROUP BY) Order The ORDER BY ... and a GROUP BY clause the SELECT clause receives groups rather than individual objects and ORDER BY ... WHERE 'Europe' MEMBER OF c.continents GROUP BY c.currency HAVING COUNT(c) > 1 ORDER BY c.currency
Manual
93

JPA Query Structure (JPQL / Criteria)

 of up to 6 clauses in the following format: SELECT ... FROM ... [WHERE ...] [GROUP BY ... [HAVING ... (update and delete queries have a slightly different form). The other JPQL clauses, WHERE, GROUP BY ... GROUP BY / HAVING (groupBy, having, count, sum, avg, min, max, ...). Criteria ORDER BY (orderBy, Order, asc, desc).
Manual
84

Chapter 4 - JPA Queries (JPQL / Criteria)

(and a criteria query) is explained by describing the main clauses of JPQL queries (SELECT, FROM, WHERE, GROUP BY, HAVING, ORDER BY): Then the expressions that are used for building JPQL and criteria query
JDO Doc
50

setGrouping(group)

Method javax.jdo.Query void setGrouping(   String group ) Set the grouping expressions, optionally including a "having" clause. When grouping is specified, each result expression must either be an expression contained in the grouping, or an aggregate evaluated once per group. Parameters: group
Tutorial
44

Step 1: Create a Maven Web Project

We start by creating a new Maven-WTP dynamic web project in Eclipse: Open the [New Project] dialog box, e.g. by using File > New > Project... Select Maven > Maven Project and click Next. Verify ... a filter, select maven-archetype-webapp in the artifact list and click Next. Enter Group Id (e.g
Tutorial
43

Step 1: Create a Maven Web Project

We start by creating a new Maven web project in NetBeans: Open the [New Project] dialog box, e.g. by using File > New Project... Select Maven > Maven Web Application and click Next. Choose a Project Name (e.g. Guestbook) and select Java EE 5. Enter Maven Group Id (e.g. com.objectdb.tutorial.spring
Manual
29

JPA Entity Fields

superclasses) can be classified into the following five groups: Transient fields Persistent fields Inverse (Mapped By) fields Primary key (ID) fields Version field The first three groups (transient, persistent ... two groups (primary key and version fields) can only be used in entity classes. Primary key fields
Result
27

ObjectDB Object Database Features

). GROUP BY (including HAVING and aggregates). ORDER BY (including ASC, DESC). Aggregates (COUNT, SUM ... attributes, grouping queries and aggregate queries) which are usually missing from Object Oriented Databases are also supported by ObjectDB. The combination of Object Database features
Forum
26

Grouping by date()

have to group by date(). For few queries I was concatenating 'date' from year()-month()-day() calls ... implementation. There is only one small problem with new version. When you group by date() there are two days per day. I mean group by divides each day for two parts. You can see an example in attached