按老板要求汇总数据
本帖最后由 爱疯 于 2013-4-1 21:48 编辑 <br /><br /><FONT class=Apple-style-span size=4 face=Arial><SPAN style="FONT-SIZE: 14px" class=Apple-style-span>老板要一份“大客户的销售汇总表”,所谓"大客户",就是总销售额>1,000,000的客户</SPAN></FONT><DIV><FONT class=Apple-style-span size=4 face=Arial><SPAN style="FONT-SIZE: 14px" class=Apple-style-span>我手上有一个销售明细表,大家来汇总啊</SPAN></FONT></DIV>
<DIV><FONT class=Apple-style-span size=4 face=Arial><SPAN style="FONT-SIZE: 14px" class=Apple-style-span>要求</SPAN></FONT></DIV>
<DIV><FONT class=Apple-style-span size=4 face=Arial><SPAN style="FONT-SIZE: 14px" class=Apple-style-span>非函数,非VBA,回复可见答题,若用SQL答题,直接贴出SQL语句即可</SPAN></FONT></DIV>
<DIV><FONT class=Apple-style-span size=4 face=Arial><SPAN style="FONT-SIZE: 14px" class=Apple-style-span>结果示例:</SPAN></FONT></DIV><BR>
<DIV align=right><FONT color=#000066></FONT> </DIV>