二名专题

查询二名和第三名sql

top是sql server的用法 SELECT t3.* FROM(SELECT top 2 t2.* FROM (SELECT top 3 NAME,SUBJECT,score,stuid FROM stuscore WHERE SUBJECT = '数学'ORDER BY score DESC) t2 ORDER BY t2.score) t3 ORDER BY t3.scor