Hi All, This is the I/p customer item1 item2 A null 100 A 200 null B null 300 B 400 null desired o/p will be as below A 200 100 B 400 300 Please help how to achieve this ?

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