red.snapper

red.snapper

[leetcode-cn] 1045-购买所有产品的客户

SELECT c.customer_id
FROM Customer c
INNER JOIN Product p
ON c.product_key = p.product_key
GROUP BY c.customer_id
HAVING COUNT(DISTINCT(c.product_key)) = (SELECT COUNT(product_key) FROM Product)
加载中...
此文章数据所有权由区块链加密技术和智能合约保障仅归创作者所有。