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

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 (*) = 3SELECT
GOODSID
FROM
EMALL_GOODS_SPEC
WHERE 
CLA