摘要: --学生表[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 阅读全文
posted @ 2013-03-25 14:26 为乐而来 阅读(166) 评论(0) 推荐(1) 编辑