[1期透视表班习题5]QUERY查询不重复记录(有奖)
<br/><div><br/></div><div>习题比较简单,希望大家多多参与!!!!</div><div>要求:利用<b> 数据-导入外部数据-新建数据库</b>功能查出<b>商品</b>字段的<b>不重复记录</b>,也就是一共有多少种商品,都罗列出来,每种商品罗列一次</div><div>用回复可见上传操作记录</div><div>有奖励哦</div><div>答案在此,看了答案再答题的就没有奖励了</div><div><br/></div>**** Hidden Message *****
**** Hidden Message *****<div><br/></div><div><font class="Apple-style-span" color="#FF0000">不错不错!听课效果不错,重奖60BB!!</font></div><div><font class="Apple-style-span" color="#FFFFFF">60BB俺给不起,只能给培训币</font></div><div><font class="Apple-style-span" color="#FF0000"> --LOTTE</font></div>
[此贴子已经被lotte于2009-11-10 10:11:16编辑过]
**** Hidden Message *****<div><br/></div><div><span class="Apple-style-span" style="font-family: tahoma, 宋体, fantasy; font-size: 12px; "><div><font class="Apple-style-span" color="#FF0000">不错不错!听课效果不错,奖励50BB!!</font></div><div><font class="Apple-style-span" color="#FFFFFF">50BB俺给不起,只能给培训币</font></div><div><font class="Apple-style-span" color="#FF0000"> --LOTTE</font></div></span></div>
[此贴子已经被lotte于2009-11-10 10:13:38编辑过]
**** Hidden Message *****
[此贴子已经被lotte于2009-11-10 11:51:27编辑过]
xuexi
**** Hidden Message *****<div><br/></div><div><span class="Apple-style-span" style="font-family: tahoma, 宋体, fantasy; font-size: 12px; "><div><font class="Apple-style-span" color="#FF0000">不错不错!听课效果不错,奖励50BB!!</font></div><div><font class="Apple-style-span" color="#FFFFFF">50BB俺给不起,只能给培训币</font></div><div><font class="Apple-style-span" color="#FF0000"> --LOTTE</font></div></span></div>
[此贴子已经被lotte于2009-11-10 11:52:43编辑过]
<p>**** Hidden Message *****</p><p><br/></p><p><span class="Apple-style-span" style="FONT-SIZE: 12px; FONT-FAMILY: tahoma, 宋体, fantasy;"><div><font class="Apple-style-span" color="#ff0000">不错不错!听课效果不错,奖励50BB!!</font></div><div><font class="Apple-style-span" color="#ffffff">50BB俺给不起,只能给培训币</font></div><div><font class="Apple-style-span" color="#ff0000"> --LOTTE</font></div></span></p><div><font class="Apple-style-span" color="#ff0000">不错不错!听课效果不错,奖励50BB!!</font></div><div><font class="Apple-style-span" color="#ffffff">50BB俺给不起,只能给培训币</font></div><div><font class="Apple-style-span" color="#ff0000"> --LOTTE</font></div><p></p><p></p>哈哈,培训币怎么给的也没有看到哟?呵呵.
[此贴子已经被作者于2009-11-11 13:49:22编辑过]
**** Hidden Message *****<div><br/></div><div><span class="Apple-style-span" style="font-family: tahoma, 宋体, fantasy; font-size: 12px; "><div><font class="Apple-style-span" color="#FF0000">与题目要求不符,奖励10BB安慰一下!!</font></div><div><font class="Apple-style-span" color="#FFFFFF">10BB俺给不起,只能给培训币</font></div><div><font class="Apple-style-span" color="#FF0000"> --LOTTE</font></div></span></div>
[此贴子已经被lotte于2009-11-10 11:55:36编辑过]
来练习一下
**** Hidden Message *****<div><br/><div><span class="Apple-style-span" style="font-family: tahoma, 宋体, fantasy; font-size: 12px; "><div><font class="Apple-style-span" color="#FF0000">不错不错!听课效果不错,奖励50BB!!</font></div><div><font class="Apple-style-span" color="#FFFFFF">50BB俺给不起,只能给培训币</font></div><div><font class="Apple-style-span" color="#FF0000"> --LOTTE</font></div></span></div></div>[此贴子已经被lotte于2009-11-10 17:55:05编辑过]