/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

5 votes263 views6 answers
Spring boot tutorial
Java Spring
0 vote226 views1 answer
Docer file spring boot
Java Spring
0 vote220 views1 answer
Spring boot init method
Java Spring
0 vote218 views1 answer
Spring boot maven run with profile
Java Spring
0 vote252 views1 answer
Spring data jpa inheritance repository
Java Spring
0 vote225 views1 answer
Log4j with spring boot restful services
Java Spring
-1 vote222 views1 answer
@notblank annotation spring
Java Spring
0 vote222 views1 answer
Period java springboot
Java Spring
0 vote222 views1 answer
Spring boot swagger ui 401
Java Spring
0 vote230 views1 answer
Testing the web layer without authentication spring
Java Spring

Share