您可以使用聚合,如下所示:
SELECT * FROM ATTRIBUTE_TAB
WHERE ID IN
(
SELECT ID FROM ATTRIBUTE_TAB
WHERE VALUE_NO='6000' OR VALUE_TEXT='TEMPERED'OR VALUE_TEXT='BLUE'
GROUP BY ID
HAVING COUNT(*) = 3 -- or maybe HAVING COUNT(DISTINCT ATTRIBUTE) = 3 if duplicates are possible
)
ORDER BY ID, ATTRIBUTE DESC
demo个