sql 计算,

[lshclshc]

id stuName birthDay Grade studentNum
1 a 2008 1 20
2 e 2007 3 10
3 c 1998 3 30
4 b 1984 1 15
5 d 1945 1 20
6 e 1988 3 15

我想计算Grade 为1 的studentNum 和,,写出一条sql语句,分不够再加,

[yuan74521940]

select sum(studentNum ) where Grade ='1'

[lshclshc]

grade sum(studentNum)

[lshclshc]

上面的试过不行,,,,,

[zabcd117]

select sum(convert(int,studentNum)) where Grade ='1'

[zhuanshen712]

select count(studentNum) where Grade ='1'

[ccaakkee]

select sum(studentNum) where Grade =1

[xiaoniao_28]

上面应该够lz来选择了 不够就试一下把错误贴出来
顺便接点分 。。。

[一品梅]

exec('declare @sum int set @sum=0 select @sum=@sum+StudentNum from table1 print @sum')

[一品梅]

select   sum(studentNum) from table1   where   Grade=1

或

exec('declare       @sum       int   set       @sum=0     select       @sum=@sum+StudentNum   from     table1  where grade=1  print       @sum')

[conan304]

select sum(studentNum) from tablename where Grade=1 --tablename自己替换

[bwangel]

select sum(studentnum) as std_sum from student where grade=1

or

select sum(studentnum) as std_sum from student group by grade having grade=1

[ezhuo]

select sum(studentnum)as SSum from student where grade=1

[syc958]

查出来总得AS成一个字段出来吧!要不你找谁呀!

[yaoleshi]

呵呵

[zhaoguoqingluntan]

呵呵

[lonelygames]

select sum(studentNum) as sumstun where Grade =1
and 与另一表相同的字段(如:stuName) in (
select stuName from 另一表 where 另一个表的条件)
或者
select sum(studentNum) as sumstun where Grade =1
and 与另一表相同的字段(如:stuName) = (
select stuName from 另一表 where 另一个表的条件)
意思就这样.不要再说还有另一个表了!!

[lshclshc]

那张客户表,字段是CustomerID,用户登录后计算Grade,

[aspnewhead]

select sum(studentNum)as a from POI group by Grade having Grade=1

[lshclshc]

是有两张表的,,
上面只给给出一张,

[bwangel]

Lz突然冒出一句话，使我联想到某些客户提出了需求，等搞好以后，突然又说：能不能再加上这个加上那个。
有感而发，不是针对LZ.