7,732
社区成员




<table border="0" align="center" cellpadding="0" cellspacing="1" class="TableBorder_1">
<tr>
<td height="30" colspan=3 align="center" class="TableTitle11"><b>不同种类数量最多的前五个站号</b></td>
</tr>
<tr>
<td align="center" class="TableRow2">排序</td>
<td align="center" class="TableRow2">站号</td>
<td align="center" class="TableRow2">数量</td>
</tr>
<%
sql="select top 5 [对应站号],count([种类]) as tj from [拖网卡片数据] where [种类] in (select b.[种类] from [拖网卡片数据] b where [种类]<>b.[种类] ) group by [对应站号] order by count([种类]) desc"
set rs=conn.execute(sql)
a=1
do while not rs.eof
%>
<tr>
<td align="center" class="TableRow2"><%=a%></td>
<td align="center" class="TableRow2"><%=rs("对应站号")%></td>
<td align="center" class="TableRow2"><%=rs("tj")%></td>
</tr>
<%
rs.movenext
a=a+1
loop
set rs=nothing
%>
</table>