select id,name,sum(sj) from stu where date between '2004-10-1' and '2004-10-30' --日期加' group by id,name --写上grou pby
select min(id) as id,name,sum(sj) from stu where date between '2004-10-1' and '2004-10-30' group by name
如果单是区分name字段的,则: select [name],sum(sj) from stu where date between 2004-10-1 and 2004-10-30 group by [name]
select id,name,sum(sj) from stu where date between '2004-10-1' and '2004-10-30' group by id,name---日期是字符串,要加单引号!另外就是要看你的sj是什么类型的!数字的就这样的代码了! 如果是其他类型的可能还要转换数据类型
select id,name,sum(sj) from stu
where date between '2004-10-1' and '2004-10-30' --日期加'
group by id,name --写上grou pby
from stu
where date between '2004-10-1' and '2004-10-30'
group by name
select [name],sum(sj) from stu
where date between 2004-10-1 and 2004-10-30
group by [name]
where date between '2004-10-1' and '2004-10-30'
group by id,name---日期是字符串,要加单引号!另外就是要看你的sj是什么类型的!数字的就这样的代码了!
如果是其他类型的可能还要转换数据类型
但是我在日期那里加了单引号不行啊,要出错啊
去掉单引号就可以了,但结果不对
还有要把这个SQL语句的结果显示出来,用ASP应该怎样写啊?