发现having count(autoid)>1 CPU性能损耗极大.
怎么解决?
SELECT top 20 SellID FROM [T_Sell_Property] WHERE (ValueString='黑色' AND LabelID=2)
GROUP BY SellID having count(autoid)>1 ORDER BY SellID DESC
这是我的语句
...全文
45610打赏收藏
having count(autoid)>1 有没有替代方法?
发现having count(autoid)>1 CPU性能损耗极大. 怎么解决? SELECT top 20 SellID FROM [T_Sell_Property] WHERE (ValueString='黑色' AND LabelID=2) GROUP BY SellID having count(autoid)>1 ORDER BY SellID DESC 这是我的语句