/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 vote413 views1 answer
Spring filter exception handling
Java Spring
0 vote448 views1 answer
Component spring
Java Spring
0 vote442 views1 answer
Which Is Better to Configure a Spring Boot Project — Properties or YAML?
Java Spring
0 vote421 views1 answer
Spring boot jackson infinite recursion
Java Spring
0 vote487 views1 answer
Entity cannot be resolved to a type in spring boot eclipse
Java Spring
0 vote495 views1 answer
How to add classpath in spring boot
Java Spring
0 vote393 views1 answer
How to load template file from resource folder in spring boot project
Java Spring
0 vote522 views1 answer
Spring websocket allow origin
Java Spring
2 votes448 views2 answers
Spring boot param object
Java Spring
0 vote437 views2 answers
Decision tree drools using spring boot
Java Spring

Share