Question

Access一个表中多个重复记录，需要只调用一条。

<%set rs=server.CreateObject("adodb.recordset")rs.open "select * from shop_action where dingdan<>'' order by actionid desc ",conn,1,1%><div class="tab"><div class="bt">最新订单</div><div class="list"><marquee direction="up" onmouseover=stop() onmouseout=start() scrollamount=1 width="100%" height="66"><div class="one"><%i=0do while not rs.eof%><div> <font color="red"><%=rs("szSheng")%>&nbsp;&nbsp;<%=rs("userxing")%><%=rs("xingbie")%></font><br><%=rs("dingdan")%><br><% if rs("zhuangtai")=1 then%>(用户还未付款)<% elseif rs("zhuangtai")=2 then %>(用户已经划出款)<% elseif rs("zhuangtai")=3 then %>(服务商已经收到款)<% else %>(服务商已经发货)<%end if %><br><br></div><%i=i+1if i>=10 then exit dors.movenextlooprs.closeset rs=nothing%></div></marquee></div></div>我需要调用<font color="red"><%=rs("szSheng")%>&nbsp;&nbsp;<%=rs("userxing")%><%=rs("xingbie")%></font><br><%=rs("dingdan")%><br>这几个字段。关键是表中有几个相同的记录，如何过滤掉重复记录，只调用其中一条？急~~搞1天了。。。

Answer 1

rs.open "Select Min(actionid) As ID,Min(szSheng) As Sheng,userxing,Min(xingbie) As 性别,Min(dingdan) As 订单,Min(zhuangtai) As 状态 From shop_action Where dingdan<>'' Group By userxing Order By Min(actionid) Desc",conn,1,1
或使用：
rs.open "SELECT * FROM 学生 WHERE xid IN (SELECT MIn(szSheng) FROM shop_action Where dingdan<>'' GROUP BY userxing ORDER By Min(actionid) Desc)",conn,1,1

效果一样，这里假设你要过滤的重复字段为“userxing”

Answer 2

过滤重复记录可用SQL代码就实现
Select 字段1，字段2（字段名改成你的字段）
FROM dbo.tbName(把TBNAME）改成你的表名
group by 字段1，字段2

Answer 3

给表定义关键字， 然后用 select distict 字段1 as sid， 字段2， 字段3 from tblname