在access中怎么写sql查询语句,查询出一个表中有不同班级同学的每个班级的前3名的学号姓名等信息?
表gq:ä¿¡æ¯è¡¨
gq_id ä¿¡æ¯ç¼å·
gq_nameãä¿¡æ¯æ é¢
gq_catid å°ç±»ç¼å·
表gq_cat:ç±»å«è¡¨ï¼å æ¬å¤§ç±»åå°ç±»
gq_catid ç±»å«ç¼å·
gq_catname ç±»å«å称
sid 大类å¼ä¸º0ï¼å°ç±»å¼ä¸ºæå±å¤§ç±»çgq_catidå¼
ç°å»ºç«ä¸ä¸ªå½æ°éè¿å¤§ç±»çç¼å·å¾å°è¯¥å¤§ç±»ä¸çåæ°æ¡ä¿¡æ¯
åæ°classid:大类ç¼å·
åæ°num:æåä¿¡æ¯æ°ç®
<%
sub gq_new(classid,num)
sqlgq="SELECT top "&num&" gq.gq_name,gq.gq_id FROM gq,gqcat where gq.gqcat_id=gqcat.gqcat_id and gqcat.sid="&classid&" order by gq.gq_id desc"
set rsgq=server.createobject("adodb.recordset")
rsgq.open sqlgq,conn,1,1
do while not rsgq.eof
Response.Write rsgq("gq.gq_name")
Response.Write "<br>"
rsgq.movenext
loop
rsgq.close
set rsgq=nothing
end sub
%>追é®
gq_id ä¿¡æ¯ç¼å·
gq_nameãä¿¡æ¯æ é¢
gq_catid å°ç±»ç¼å·
表gq_cat:ç±»å«è¡¨ï¼å æ¬å¤§ç±»åå°ç±»
gq_catid ç±»å«ç¼å·
gq_catname ç±»å«å称
sid 大类å¼ä¸º0ï¼å°ç±»å¼ä¸ºæå±å¤§ç±»çgq_catidå¼
ç°å»ºç«ä¸ä¸ªå½æ°éè¿å¤§ç±»çç¼å·å¾å°è¯¥å¤§ç±»ä¸çåæ°æ¡ä¿¡æ¯
åæ°classid:大类ç¼å·
åæ°num:æåä¿¡æ¯æ°ç®
<%
sub gq_new(classid,num)
sqlgq="SELECT top "&num&" gq.gq_name,gq.gq_id FROM gq,gqcat where gq.gqcat_id=gqcat.gqcat_id and gqcat.sid="&classid&" order by gq.gq_id desc"
set rsgq=server.createobject("adodb.recordset")
rsgq.open sqlgq,conn,1,1
do while not rsgq.eof
Response.Write rsgq("gq.gq_name")
Response.Write "<br>"
rsgq.movenext
loop
rsgq.close
set rsgq=nothing
end sub
%>追é®
éè¦åselectè¯å¥
温馨提示:答案为网友推荐,仅供参考