Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Market Basket analysis (MBA) query sample

Author  Topic 

usafelix
Posting Yak Master

165 Posts

Posted - 2014-08-24 : 11:37:20
Anyone can help give simple MBA query for retail sales in sales two invoice based on sample one item.

For This sales invoice have 3 items.
Inv 001
item A amount $5
item b amount $1
item C aount $3

Inv 002
Item A amount $5
Item C amount $10
item C amount $10
item D amount $5

what products are often sold together ?
   

- Advertisement -