I have a price list that contains about 14000 items. My problem is that there are multiple items with the same name, but different prices. I want to run a query that will show distinct names and only show the lowest price. I'm just not quite sure how to tackle this problem.
Thanks in advance