This content has been marked as final. Show 3 replies
There is a need to have a comma separated list of shops offering minimal and maximal price of a product.
It is quite simple to get min and max prices, but difficult to get corresponding values in other field
DISTINCT aggr(if(price=Min(total<product> price),shop),
works only if there is just one shop with minimal price. No shop list in case several shops with equal minimal price
Any advice will be helpful!
See example attached