/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 vote353 views1 answer
Spring boot procfile run profile
Java Spring
0 vote395 views1 answer
Entity cannot be resolved to a type in spring boot eclipse
Java Spring
0 vote335 views1 answer
Get value from Spring application.properties
Java Spring
0 vote368 views1 answer
Spring data jpa inheritance repository
Java Spring
0 vote347 views1 answer
How to encrypt password in properties file in spring boot
Java Spring
0 vote323 views1 answer
Spring org.springframework.stereotype not visible
Java Spring
0 vote323 views1 answer
Authentication in spring boot
Java Spring
0 vote326 views1 answer
Period java springboot
Java Spring
1 vote347 views2 answers
Spring-boot java header Content-Type constant
Java Spring
0 vote349 views2 answers
Spring boot send email html template
Java Spring

Share