在SQL中使用sum和group by [英] Use of sum and group by in SQL

问题描述

你好家伙

希望每个人都没事。

i每个人都有一个问题请给我解决我的问题

i try同时使用sum函数，内连接和group by子句但它不工作

请任何人告诉我我该怎么做

i尝试这段代码但它显示错误



我的尝试：

选择s。[ProModelNo] +''+ p.ConditionPro +''+ p.ItemType作为'Item Description'，
 s。[ComName] as'ComName'，
 sum（s.AvailableQty）作为'Avil'
来自[dbo]。[股票] s 
内部联接[产品] p 
 on p.ModelNo = s.ProModelNo 
 group by [ProModelNo]，[ ComName] 
有sum（s.AvailableQty）= 0或sum（s.AvailableQty）= 1 
 

解决方案

< blockquote>请参见： SQL GROUP By和专栏名称'在选择列表中无效，因为......错误 [ ^ ]

Hi guy's
hope every one is fine.
i have one question from every one please give me the solution of my problem
i try to use sum function, inner join and group by clause in same time but its not working
please any one tell me how can i do this
i try this code but it show error

What I have tried:

    select s.[ProModelNo]+' '+p.ConditionPro+' '+p.ItemType    as 'Item Description',
     s.[ComName]       as'ComName',
 sum(s.AvailableQty)   as 'Avil'
from [dbo].[Stock] s
inner join [Products] p
on p.ModelNo=s.ProModelNo
group by  [ProModelNo],[ComName]
having  sum(s.AvailableQty)=0 or sum(s.AvailableQty)=1

解决方案

See here: SQL GROUP By and the "Column 'name' is invalid in the select list because..." error[^]

这篇关于在SQL中使用sum和group by的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！