trying to find out the most occurence product id by having a table called productidtable
id productid pidcounter
1 1 12
2 2 6
3 3 2
apparently productid 1 is the most occurence, with pidcounter 12,
with the code behind as follow, it does not produces result as above table but this result
id productid pidcounter
1
1
2
665
2
1
666
2
1 Go to the complete details ...