<script type="text/javascript">
</script> <script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script>
/*--原帖地址:http://community.csdn.net/Expert/topic/3845/3845290.xml?temp=.3689386--*/
--测试数据createtabletb(编号int,性质varchar(10),数量int,指标1decimal(10,1),指标2decimal)inserttbselect1,'00',10,1.1,10unionallselect2,'01',20,1.2,20unionallselect3,'00',30,1.5,10unionallselect4,'01',40,1.9,35unionallselect5,'00',40,1.2,20
/*--处理要求
要求得到下述结果:
a 范围 性质(00) 性质(01) -------------------------------------------------------------指标1 <1.0 .00 .00 1.0-1.29 .63 .63 1.3-1.59 .38 .38 1.9-1.99 .00 .00 >=2 .00 .00指标1平均值 1.27 1.55指标2 <10 .00 .00 10-31 1.00 1.00 31-50 .00 .00 >=50 .00 .00指标2平均值 13.33 27.50数量合计: 80.00 60.00------------------------------------------------------------------ 1 <script type="text/javascript"> </script> <script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script>
<script type="text/javascript">
</script><script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script>
/*--原帖地址:http://community.csdn.net/Expert/topic/3845/3845290.xml?temp=.3689386--*/
--测试数据createtabletb(编号int,性质varchar(10),数量int,指标1decimal(10,1),指标2decimal)inserttbselect1,'00',10,1.1,10unionallselect2,'01',20,1.2,20unionallselect3,'00',30,1.5,10unionallselect4,'01',40,1.9,35unionallselect5,'00',40,1.2,20
/*--处理要求
要求得到下述结果:
a 范围 性质(00) 性质(01) -------------------------------------------------------------指标1 <1.0 .00 .00 1.0-1.29 .63 .63 1.3-1.59 .38 .38 1.9-1.99 .00 .00 >=2 .00 .00指标1平均值 1.27 1.55指标2 <10 .00 .00 10-31 1.00 1.00 31-50 .00 .00 >=50 .00 .00指标2平均值 13.33 27.50数量合计: 80.00 60.00------------------------------------------------------------------ 1 <script type="text/javascript"> </script> <script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script>
<script type="text/javascript">
</script><script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script>