这个查询在C＃中给我错误“ '>'附近的语法错误我该如何解决？

问题描述

选择StockId作为[股票ID]，（ProductName）作为[产品名称]，功能，总和（数量）作为[数量]，价格，总和（TotalPrice）作为[总价格]来自Config，Stock其中Config.ConfigID = Stockid，Stockid，按产品名称，功能，价格总和（数量> 0）按产品名称排序，con;

SELECT StockId as [Stock ID], (ProductName) as [Product Name],Features,sum(Quantity) as [Quantity],Price,sum(TotalPrice) as [Total Price] from Config,Stock where Config.ConfigID=Stock.ConfigID group by Stockid, productname,features,price having sum(Quantity > 0) order by Productname",con;

推荐答案

group by Stockid, productname,features,price having sum(Quantity > 0) order by Productname",con;

要

To

group by Stockid, productname,features,price having sum(Quantity) > 0 order by Productname",con;

这篇关于这个查询在C＃中给我错误“ '>'附近的语法错误我该如何解决？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！