如图:(表名叫 ExamStudentScoreInfo)
sql语句:
select * from ExamStudentScoreInfo ess
where not exists(select 1 from ExamStudentScoreInfo where username = ess.username and other2 < ess.other2 and ExamId=ess.ExamId)
如图:(表名叫 ExamStudentScoreInfo)
sql语句:
select * from ExamStudentScoreInfo ess
where not exists(select 1 from ExamStudentScoreInfo where username = ess.username and other2 < ess.other2 and ExamId=ess.ExamId)