See the example of Hibernate native SQL query with GROUP BY Clause, Also this query contains the logic to retrieve the data in a date range in mysql
Query query = this.sessionFactory.getCurrentSession().createSQLQuery( "SELECT expenseHead, sum(expense) FROM mb.expense where date<=':date2' and date>= ':date1' group by expenseHead;") .setParameter("date2", date2) .setParameter("date1", date1); List result = query.list(); return result;
Comments
Post a Comment
Please type your comments here