/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 vote249 views1 answer
Spring converter in initbinder
Java Spring
0 vote222 views1 answer
Test thrown expected with jupiter spring boot
Java Spring
0 vote221 views1 answer
Update role spring security
Java Spring
0 vote206 views1 answer
How to change the tomcat port in spring boot
Java Spring
0 vote219 views3 answers
Diiferent ways to run spring boot
Java Spring
0 vote134 views2 answers
How to send gmail using spring boot in java code
Java Spring
0 vote213 views1 answer
How to encrypt password in properties file in spring boot
Java Spring
0 vote203 views1 answer
@bean annotation in spring boot
Java Spring
0 vote220 views3 answers
Spring boot sql logging
Java Spring
1 vote305 views1 answer
Spring execute code after variable injected
Java Spring

Share