求圣人！

2012-08-13

求高人！！！怎么样才查出哪些行参与了平均数计算？平均数的计算方法是：(先算的是a的并且在范围内的平均值，b是

求高人！！！
怎么样才查出哪些行参与了平均数计算？

平均数的计算方法是：(先算的是a的并且在范围内的平均值，b是比例，然后是统计)

SQL code

SELECT  [name], AVG(a) as a, SUM(CASE WHEN b<=5 THEN 1 ELSE 0 END) * 100.0 / COUNT(b) AS bFROM  taGROUP BY namehaving AVG(a)>'1'UNION ALL SELECT  '统计', AVG(a) as a,AVG(b) as bFROM(SELECT  [name], AVG(a) as a, SUM(CASE WHEN b<=5 THEN 1 ELSE 0 END) * 100.0 / COUNT(b) AS bFROM  taGROUP BY namehaving AVG(a)>'1')ta

数据库是：数据随意

name a b

[解决办法]
那些行是什么意思？

满足条件的行都参加了啊

SQL code

select * from tawhere name in(SELECT  [name]FROM  taGROUP BY namehaving AVG(a)>1)

热点排行

Bad Request.

SQL Server

求圣人！