sql = "select top 6 from Dat_Information where infokey in(Select top 10 infokey From Dat_Information where clsid = 1 order by infokey desc ) order by infokey asc"
<%set rs=server.createobject("adodb.recordset")
sql = "select top 7 * from [Dat_Information] where clsid = 1 order by infokey desc"
rs.open sql,conn,1,1
%>
如果要这这样的语句要怎么写叱。