UC知道ASP 不重复 高分处理
来源：百度知道 编辑：UC知道 时间：2024/07/07 10:27:22
<%Set rs=Server.CreateObject("ADODB.Recordset")
sql="select top 9178 a.id,a.mc,a.js,a.tui,a.vip,a.logo,a.dz,a.tel,a.qq from qy_info as a inner join qy_chanpin as b on a.id=b.qy_id where b.lbid="&s.shuzi("lbid")&" and b.xlbid="&s.shuzi("xlbid")&" and a.zt=1 order by a.vip desc,a.ding desc,a.id desc"
rs.open sql,conn,3,1
page1("10")
i=1
do while not rs.eof and i<=rs.pagesize
%>
读取函数字段 a.mc 不重复，帮忙处理，谢谢！
sql="select top 9178 a.id,a.mc,a.js,a.tui,a.vip,a.logo,a.dz,a.tel,a.qq from qy_info as a inner join qy_chanpin as b on a.id=b.qy_id where b.lbid="&s.shuzi("lbid")&" and b.xlbid="&s.shuzi("xlbid")&" and a.zt=1 order by a.vip desc,a.ding desc,a.id desc"
rs.open sql,conn,3,1
page1("10")
i=1
do while not rs.eof and i<=rs.pagesize
%>
读取函数字段 a.mc 不重复，帮忙处理，谢谢！
sql="select top 9178 distinct a.mc ,a.id,a.js,a.tui,a.vip,a.logo,a.dz,a.tel,a.qq from qy_info as a inner join qy_chanpin as b on a.id=b.qy_id where b.lbid="&s.shuzi("lbid")&" and b.xlbid="&s.shuzi("xlbid")&" and a.zt=1 order by a.vip desc,a.ding desc,a.id desc"
Distinct