/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

0 vote333 views1 answer
Spring boot default value false
Java Spring
0 vote342 views1 answer
Check authorities spring
Java Spring
0 vote328 views1 answer
Spring boot maven run with profile
Java Spring
1 vote381 views1 answer
@SpringBootApplication
Java Spring
2 votes410 views1 answer
Spring boot resource optional request param
Java Spring
0 vote334 views1 answer
Thymeleaf spring boot dependency for mail
Java Spring
0 vote358 views2 answers
Decision tree drools using spring boot
Java Spring
0 vote338 views1 answer
SpringBootStarter maven dependency
Java Spring
0 vote406 views1 answer
Spring data sql not utf8
Java Spring
0 vote335 views1 answer
Configuration spring boot dependency for freemarker configuration
Java Spring

Share