Skip to Content
0
Feb 02, 2023 at 09:31 AM

SAP CAP Java - CQL SELECT with SUM

323 Views

HI Teams,

We have a view that we need to query, but need the sum of a column.

SELECT SUM(CARDCOUNT), ID

FROM XVIEW

WHERE TDATE >= '2023-02-01' AND TDATE <= '2023-02-02'

GROUP BY ID;

How do we write this in CQL for Java??

Thanks for your help.

Cheers

Dharmesh