Hi Rahul,

Please use the below query to get the no.of unique products purchased by Customer

SELECT [Custmoer NO],COUNT(DISTINCT [product name]) AS NoOfProductsPerCustomer

FROM @Customer_Bill_Table

GROUP BY [Custmoer NO]

Let me know if this is not clear.

Thanks, Satish