Hey guys,
I am not the strongest SQL developer, I just have a quick question checking if this is possible.
I have the following table:
Itemsets
itemsetid productid
| 1 | 5 |
| 1 | 6 |
| 2 | 5 |
| 2 | 9 |
What I want to do is return all the itemsets and know how many are there.
What I want returned:
[[1(5,6)],[2(5,9)]] -> length of this = 2(number of itemsets)
Something along these lines.
Any help is greatly appreciated,
Thanks