set rs=server.createojbect("adodb.recordset")
sql="select name from mobile"
rs.open sql,conn,1,1
do until rs.eof
response.write rs("name")&" 2台"
rs.movenext
loop
rs.close
sql="select name from mobile"
rs.open sql,conn,1,1
do until rs.eof
response.write rs("name")&" 2台"
rs.movenext
loop
rs.close
FROM mobile
GROUP BY name