/SQL/How to take sum of column with same id in "JPQL?"

How to take sum of column with same id in "JPQL?"

public interface CodeRepository extends JpaRepository<Code, Integer> {
    @Query("select c.code, c.name, count(l) as amount from Code c join c.counterList l group by c.code, c.name")
    List<Object[]> getSummary();
}

Source: stackoverflow.com

Similar codes

0 vote225 views1 answer
Sql script to remove default from column
SQL
1 vote214 views1 answer
Mysql check string don't have number
SQL
1 vote206 views1 answer
Simple project for database
SQL
0 vote213 views1 answer
Mysql select statement after index
SQL
3 votes219 views2 answers
Update part of a string in mysql
SQL
0 vote236 views1 answer
Site:av.ru "files"
SQL
0 vote203 views1 answer
Monthly Birthday SQL Query
SQL
2 votes230 views2 answers
Python escape string for sql
SQL
3 votes205 views1 answer
How to find names includes in sql
SQL
0 vote227 views1 answer
How to find symmetric pairs in sql
SQL