开发者

Select cheapest where sku or ean is even

开发者 https://www.devze.com 2023-03-05 14:45 出处:网络
I\'ve a simple query like: SEL开发者_开发百科ECT id, name, price, sku, ean FROM products WHERE id IN (1,2,3,4,5,6)

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?

0

精彩评论

暂无评论...
验证码 换一张
取 消