spring jpa group by query method

Leo

Code: Whatever

2021-09-09 08:36:59

@Query("SELECT c.year, COUNT(c.year) FROM Comment AS c GROUP BY c.year ORDER BY c.year DESC")
	List<Object[]> countTotalCommentsByYear();

New to Communities?

Join the community