摘要:
--学生表[Table_Student]{[StudentID],[Sex],[StudentName]}--科目表 [Table_Class]{[CalssID],[ClassName]}--成绩表 [Table_score]{[StudentID],[ClassID],[Score]}查出各科目中前10的学生学号和成绩select * from Table_score as CJ1 where score >= ( select Min(score) From Table_score As CJ2 Where CJ1.classid = CJ2.classid And CJ1.sco 阅读全文