/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 vote427 views1 answer
Spring data jpa inheritance repository
Java Spring
0 vote422 views1 answer
Add image in loggin view spring boot security
Java Spring
4 votes477 views1 answer
Dependency for spring security
Java Spring
5 votes492 views2 answers
Gradle springboot run
Java Spring
0 vote427 views1 answer
Spring boot send username in email html template
Java Spring
0 vote409 views1 answer
Data.sql not loading in springboot
Java Spring
0 vote412 views2 answers
Spring boot rest api
Java Spring
3 votes575 views3 answers
Spring mvc
Java Spring
0 vote389 views1 answer
How to secure specific url in spring security
Java Spring
0 vote378 views1 answer
Quartz spring maven driver
Java Spring

Share