How to find with data and sum of field

Question

In my Project, I hava a data base table is like that

This query in JPQL query I have find select c from SalesInvoice c where c.invoicedate BETWEEN :from AND :to how to find sum of amount field. I need find data field and summation of amount field one query

• In my javafx Project tableview.setItem(query) tableView will persist

Answer 1

Use Aggregate function SUM to find the sum and group by on the column which you want to find the sum...