类似淘宝的多规格条件筛选查询

SELECT
GOODSID
FROM
EMALL_GOODS_SPEC
WHERE 
CLASSID=669 AND
((SPECID = 5 AND SPEC_VALUEID = 9)
OR (SPECID = 6 AND SPEC_VALUEID = 51)
  OR (SPECID = 3 AND SPEC_VALUEID = 5))
GROUP BY
GOODSID
HAVING
COUNT (*) = 3

这种方式相对精准一些。

SELECT DISTINCT
	S.GOODSID
FROM
	EMALL_GOODS_SPEC
WHERE
	S.SPECID IN (3, 5)
AND S.SPEC_VALUEID IN (5, 6)
AND S.CLASSID = 669;

这种不是太准确

为了写这个。。。