1.总成绩表
ClassID StudentID SumFen(总分)
------------------------------------
000005 000001 503
000005 000003 498
000004 000006 487
000004 000003 501
2、分段间隔 N=10 可能N=20
结果:
500-510 490-500 480-490
000004 1 0 1
000005 1 1 0
(要不access 中用呀)
ClassID StudentID SumFen(总分)
------------------------------------
000005 000001 503
000005 000003 498
000004 000006 487
000004 000003 501
2、分段间隔 N=10 可能N=20
结果:
500-510 490-500 480-490
000004 1 0 1
000005 1 1 0
(要不access 中用呀)
ClassID StudentID SumFen(总分)
------------------------------------
000005 000001 503
000005 000003 498
000004 000006 487
000004 000003 501
2、分段间隔 N=10 可能N=20
结果:
500-510 490-500 480-490
000004 1 0 1
000005 1 1 0
(要 在access 中用呀)
sum(IIf([SumFen]>500 And [SumFen]<=510,1,0)) AS [500-510],
sum(IIf([SumFen]>490 And [SumFen]<=500,1,0)) AS [490-500],
sum(IIf([SumFen]>480 And [SumFen]<=490,1,0)) AS [480-490]FROM Tt
GROUP BY [ClassID]
select Convert(varchar(5),(convert( int, price/1000)-1)*1000) +'~' + Convert(varchar(5),convert( int, price/1000)*1000),
sum(price)
from #bb
group by Convert(varchar(5),(convert( int, price/1000)-1)*1000) +'~' + Convert(varchar(5),convert( int, price/1000)*1000)