/Java/Spring/Spring jpa group by query method

Spring jpa group by query method

Spring jpa group by query method

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

-1

Source: baeldung.com

Similar codes

3 votes353 views3 answers
Repository query spring boot
Java Spring
0 vote246 views1 answer
Test thrown expected with jupiter spring boot
Java Spring
0 vote232 views1 answer
Java spring username encode and decode
Java Spring
3 votes345 views3 answers
Spring mvc
Java Spring
5 votes321 views2 answers
Gradle springboot run
Java Spring
4 votes326 views1 answer
Dependency for spring security
Java Spring
0 vote226 views1 answer
GetMapping("/rest/v1/books") in spring rest api
Java Spring
0 vote232 views1 answer
How to set two different table admin and user for separate jwt token in spring boot
Java Spring
0 vote230 views1 answer
Quartz spring maven driver
Java Spring
0 vote257 views1 answer
Spring aop xml definition
Java Spring

Share