28,409
社区成员




set rs1=server.createobject("adodb.recordset")
set rs2=server.createobject("adodb.recordset")
set rs3=server.createobject("adodb.recordset")
sql1="select top 1* from 表 where type=1 order by id"
sql2="select top 1* from 表 where type=2 order by id"
sql3="select top 1* from 表 where type=3 order by id"
rs1.open sql1,conn,1,1
rs2.open sql2,conn,1,1
rs3.open sql3,conn,1,1
for i=0 to rs1.recordcount
i=i+1
response.write(rs1("id")&" "&rs2("type"))
response.write(rs2("id")&" "&rs2("type"))
response.write(rs3("id")&" "&rs3("type"))
if i=1 then
one=""
two=""
three=""
end if
one=one&"and id<>"&rs1("id")
two=two&"and id<>"&rs2("id")
three=three&"and id<>"&rs3("id")
set rs11=server.createobject("adodb.recordset")
set rs22=server.createobject("adodb.recordset")
set rs33=server.createobject("adodb.recordset")
sql11="select top 1 * from 表 where type=1"&one&" order by id"
sql22="select top 1 * from 表 where type=2"&two&" order by id"
sql33="select top 1 * from 表 where type=3"&three&" order by id"
rs11.open sql11,conn,1,1
rs22.open sql22,conn,1,1
rs33.open sql33,conn,1,1
response.write(rs1("id")&" "&rs2("type"))
response.write(rs2("id")&" "&rs2("type"))
response.write(rs3("id")&" "&rs3("type"))
rs11.close
rs22.close
rs33.close
set rs11=nothing
set rs22=nothing
set rs33=nothing
next
rs1.close
rs2.close
rs3.close
set rs1=nothing
set rs2=nothing
set rs3=nothing
select top 3 * from [表] where type in(select type from[表] group by type) order by type