要固定的排名顺序，就算没有人排野山给他空着排名顺序，先谢谢各位热心的朋友帮忙了
<%
Set OBJConn = Server.CreateObject("ADODB.Connection")
OBJConn.Open "xs","sa","123456"
sersql="select xm,yj from baobiao order by b.yj desc"
Set rs=OBJConn.Execute (sersql)
%>

<tr>
<td>姓名</td>
<td>业绩</td>

<tr>
<%do while not rs.eof%>
<tr>
<td><%=rs("xm")%></td>
<td><%=rs("yj")%></td>

</tr>

<%