How to get result by multiple index

[Insua]

Like sql "SELECT * FROM table WHERE A=1 AND B=2"

[TheWinds]

hello,to slove this problem you can use the CompoundMultiIndex.
if you want the program automic decide which index to choose,you should implement index match by yourself and then filter the reuslt for the field which not matched.

[AhmedSiddiquibBenchMatrix]

How to use group by clause in memdb like
SELECT SUM(CLIENT.TRANSACTIONS.TRANSACTION_AMT) TOTAL_AMOUNT,COUNT(CLIENT.TRANSACTIONS.TRANSACTION_ID) NO_OF_TRANACTIONS,CLIENT.TRANSACTIONS.CUSTOMER_ID
FROM CLIENT.TRANSACTIONS GROUP BY CLIENT.TRANSACTIONS.CUSTOMER_ID
I want to execute this query but how to do this in memdb