Question

asp 读取数据不显示重复数据

原文是这样写的，但是读取的数据有重复出现的情况，如何修改能不显示重复的数据？
<%
where="1=1"
if xmman_key <>"" then
where=where&" and aaa like '%"&xmman_key&"%' "
end if
set rs=Conn.Execute("select aaa,bbb from oracle where "&where)
i=0

do while not rs.eof
i=i+1

%>
rstr+='<tr class="tr1" onclick="tdonclick(\'<%=rs("aaa")%>\',\'xmman\')" onmouseover="tdmouseover(this)" onmouseout="tdmouseout(this)"><td style="background:menu;height:18px;"></td><td ><%=RS("aaa")%></td><td ><%=rs("bbb")%></td></tr>\r\n';
<%
rs.movenext:loop:Set rs=Nothing
%>
rstr+="</table>";
parent.document.getElementById("xmman_list").innerHTML=rstr;

Answer 1

set rs=Conn.Execute("select aaa,bbb from oracle where "&where)

修改成

set rs=Conn.Execute("select aaa,bbb from oracle where "&where & " group by aaa,bbb")