28,409
社区成员




<%
set rs=server.CreateObject("adodb.recordset")
rs.open "select Name,count(id) as tota1 from table1 group by Name order by tota1 desc",conn,1,1
do while not rs("total")<2
response.Write(rs("name")&rs("tota1")&"<br>")
rs.movenext
loop
rs.close
set rs=nothing
%>
rs.open "select Name,count(id) as tota1 from table1 group by Name order by tota1 desc",conn,1,1
是tota1不是total,最后一个字符你在SQL中是1