I've a simple query like:
SEL开发者_开发百科ECT id, name, price, sku, ean
FROM products
WHERE id IN (1,2,3,4,5,6)
ORDER BY name ASC
Some products are double present (same sku or ean) with diffrent prices.
How to select the cheapest products where sku or ean is the same?
精彩评论