I have customer details as below, cust_card_no item amount 10001 pen 10 10001 copy 20 10001 pen 10 10001 copy 20 10001 copy 20 now my question is to find the distinct count of item per customer and total ammount spend by a customer?

Shubam Salaria

• Aug 3rd, 2023

What does vector_search() func do?

anjali

• Sep 14th, 2020

Car_no item count amount
1001 copy 3 60
1001 pen 2 20
is it the desired output ?

Answer Question  Select Best Answer