我如何处理已经尝试过多种方式的查询,但它不起作用。我正在尝试仅显示与ShopNo具有3种以上组合的CentreCode
SELECT CentreCode, ShopNo
FROM shoppingcentreshop
WHERE (SELECT count(*) as total FROM shoppingcentreshop GROUP BY CentreCode) > 2
SELECT CentreCode, ShopNo, (SELECT count(*) AS total FROM shoppingcentreshop GROUP BY CentreCode) AS table1
FROM shoppingcentreshop
WHERE table1.total > 2
在WHERE子句中使用相关子查询,而无需group by
:
SELECT s.CentreCode, s.ShopNo
FROM shoppingcentreshop s
WHERE (SELECT COUNT(*) FROM shoppingcentreshop WHERE CentreCode = s.CentreCode) > 2
本文收集自互联网,转载请注明来源。
如有侵权,请联系 [email protected] 删除。
我来说两句