group by 分组求和或别的方法求和,求解决,急急急!!!
已用group by, 但就是不求和
怎么把物料编号相同的数量、金额相加? --------------------编程问答-------------------- 你的代码太乱了
能不能像我这样写
select a,count(1) num from tab1 group by a--------------------编程问答-------------------- group by看着没问题啊,结果输出了什么? --------------------编程问答-------------------- 参考
--------------------编程问答-------------------- 怎么把物料编号相同的数量、金额相加?
struct Material
{
private string no;
public string NO
{
get { return no; }
set { no = value; }
}
private int count;
public int Count
{
get { return count; }
set { count = value; }
}
}
private void button1_Click(object sender, EventArgs e)
{
List<Material> list = new List<Material>();
Material m = new Material();
m.NO = "a";
m.Count = 10;
list.Add(m);
m = new Material();
m.NO = "a";
m.Count = 40;
list.Add(m);
m = new Material();
m.NO = "c";
m.Count = 30;
list.Add(m);
var vs = list.GroupBy(x => x.NO).Select(v => new { num = v.Sum(y=>y.Count) });
foreach (var v in vs)
{
MessageBox.Show(v.num.ToString());
}
}
select 物料编号,sum(数量) as 数量,sum(金额) as 金额
from tb
group by 物料编号
having count(*)>1 /*至少两个物料编号以上*/
补充:.NET技术 , ASP.NET