row multiplication in Hibernate Criteria

Question

How to implement the following SQL query using Hibernate Criteria API:

SELECT
    SUM(field1) as s,
    SUM(field1 * field2) as m
FROM 
    table

score 1 · Accepted Answer · answered May 19 '15 at 13:13

1

Try

add(Projections.sqlProjection("sum(field1)) AS s", new String[] { "s" }, new Type[] {Hibernate.DOUBLE }))
add(Projections.sqlProjection("sum(field1*field2) AS m", new String[] { "m" }, new Type[] {Hibernate.DOUBLE }))

answered May 19 '15 at 13:13

Rockstar

2,228
3
20
39

Maybe you want to explain why? – NathanOliver May 19 '15 at 14:41

row multiplication in Hibernate Criteria

1 Answers1