/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 vote230 views1 answer
@bean annotation in spring boot
Java Spring
0 vote226 views1 answer
Get value from Spring application.properties
Java Spring
0 vote227 views1 answer
Log4j with spring boot restful services
Java Spring
0 vote226 views1 answer
Using UUID spring boot Neo4J
Java Spring
0 vote232 views1 answer
Spring commandlinerunner example
Java Spring
0 vote238 views2 answers
Spring boot rest api
Java Spring
0 vote212 views1 answer
How to load template file from resource folder in spring boot project
Java Spring
-1 vote272 views1 answer
@notblank annotation spring
Java Spring
0 vote217 views1 answer
Spring boot bean configuration
Java Spring
0 vote245 views1 answer
Spring boot return 201 created
Java Spring

Share