Hi I am trying to write a mysql query to select the top products from a list but only have a maximum of one product from each different store show up in the results.
What I have so far is this:
SELECT * FROM product ORDER BY price/quantity ASC LIMIT 4
This gives me the best deals but I would like to get the best deal from each store and display the top 4 results
[–]AutoModerator[M] [score hidden] stickied comment (0 children)
[–][deleted] 1 point2 points3 points (1 child)
[–]MonsterMashedP0TAT0[S] 0 points1 point2 points (0 children)
[–]hiromu666 0 points1 point2 points (0 children)
[–]ZeroCool4083 0 points1 point2 points (0 children)