>符合条件进行合计,不符合条件的显示出来,如何实现?<

[heavenmusic]

ID 姓名 数学 班级
1 aa 80 1
2 bb 90 2
3 cc 67 1
4 dd " " 2
----------------------

我想要的结果是:

班级 数学
1 147
2 " "

我设置的条件是 数学成绩为 空时,要显示 相关信息.
(请原谅我举例不是十分合理,如果不太明白,请与我联系.)

QQ: 147484507 谢谢大家.

[heavenmusic]

谢谢你的帮助.

朋友,对于你的语言,可以给我解释一下吗?

WHERE (数学 = '')) THEN '' ELSE SUM(cast(数学 AS int)) END AS 成绩

[heavenmusic]

我这个语句,主要用在ACCESS里面.

[zhenmeiyisi]

CASE 班级 WHEN
(SELECT 班级
FROM tab1
WHERE (数学 = '')) THEN '' ELSE SUM(cast(数学 AS int)) END AS 成绩


先找出数学等于空的班级,再把该班级的数学成绩 写成 ''

[zhenmeiyisi]

哦 , access 里没有 case when

好像是用 iff

[zhenmeiyisi]

是iif

[heavenmusic]

SELECT [ALL | DISTINCT] [TOP nExpr [PERCENT]] [Alias.] Select_Item
[[AS] Column_Name] [, [Alias.] Select_Item [[AS] Column_Name] ...]
FROM [FORCE] [DatabaseName!] Table [[AS] Local_Alias]
[ [INNER | LEFT [OUTER] | RIGHT [OUTER] | FULL [OUTER] JOIN DatabaseName!]
Table [[AS] Local_Alias] [ON JoinCondition ...]
[[INTO Destination] | [TO FILE FileName [ADDITIVE] | TO PRINTER [PROMPT] | TO SCREEN]]
[PREFERENCE PreferenceName] [NOCONSOLE] [PLAIN] [NOWAIT]
[WHERE JoinCondition [AND JoinCondition ...] [AND | OR FilterCondition [AND | OR FilterCondition ...]]]
[Group By GroupColumn [, GroupColumn ...]] [HAVING FilterCondition] [UNION [ALL] SELECTCommand]
[Order By Order_Item [ASC | DESC] [, Order_Item [ASC | DESC] ...]]

里面,好像没有"when"...............

[heavenmusic]

好像没有看到 iif???

[zhenmeiyisi]

:)

up

[zhenmeiyisi]

CREATE TABLE tab1(id int, 姓名 varchar(100), 数学 varchar(10), 班级 varchar(10))
insert into tab1 select 1,'aa','80','1' union all
select 2,'bb','90','2' union all
select 3,'cc','67','1' union all
select 4,'dd','','2'




SELECT 班级, CASE 班级 WHEN
(SELECT 班级
FROM tab1
WHERE (数学 = '')) THEN '' ELSE SUM(cast(数学 AS int)) END AS 成绩
FROM tab1
GROUP BY 班级

[heavenmusic]

有人可以帮助我一下吗??? 请.....help me ......