/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 vote211 views1 answer
What singleton java spring
Java Spring
-1 vote267 views1 answer
@notblank annotation spring
Java Spring
4 votes341 views1 answer
Spring load config value in variable
Java Spring
-2 votes224 views6 answers
Spring enable cors
Java Spring
0 vote209 views1 answer
Database springboot
Java Spring
0 vote215 views1 answer
How to read html file from resource folder from spring project by using maping
Java Spring
1 vote211 views2 answers
Spring-boot java header Content-Type constant
Java Spring
3 votes347 views2 answers
Spring boot example with swagger
Java Spring
0 vote216 views1 answer
ClassNotFoundException: org.springframework.ui.freemarker.FreeMarkerConfigurationFactory
Java Spring
0 vote242 views1 answer
How to encrypt password in properties file in spring boot
Java Spring

Share