Search code examples
hibernatejpajpql

What is return type of AVG function in JPQL?


I am using AVG function in JPQL named query. But I am getting error Unable to locate appropriate constructor on class I have tried taking it in Integer, Float, BigDecimal variable but still it didn't work.

I am calculating Average of bigDecimal values. Even I tried as AVG(CAST(s.marks AS FLOAT))

Can anybody please help?


Solution

  • Finally done. It returns as Double