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