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?
Finally done. It returns as Double