/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 vote134 views1 answer
Add image in loggin view spring boot security
Java Spring
0 vote132 views1 answer
Spring Boot - Hashicorp Vault Integration
Java Spring
0 vote128 views1 answer
Using UUID spring boot Neo4J
Java Spring
0 vote116 views1 answer
Keycloak spring boot application.properties
Java Spring
2 votes121 views2 answers
Spring boot postgres
Java Spring
1 vote132 views1 answer
Spring xml file configuration
Java Spring
0 vote119 views2 answers
Springbootservletinitializer maven dependency
Java Spring
0 vote126 views1 answer
Spring data sql not utf8
Java Spring
0 vote144 views1 answer
Spring boot return 201 created
Java Spring
0 vote117 views1 answer
Thymeleaf spring boot dependency for mail
Java Spring

Share