34,588
社区成员
发帖
与我相关
我的任务
分享
select tstu.f_code+ ':' +tstu.f_strrealname as '学号:姓名',ce.f_examname2 as 考试名称,cast(cbs.f_subject01 as decimal(15,2)) as 语文,cast(cbs.f_subject02 as decimal(15,2)) as 数学,cast(cbs.f_subject03 as decimal(15,2)) as 英语 from C_BasicScore as cbs
left join C_Exam as ce on ce.f_guid=cbs.f_examguid
left join t_student as tstu on tstu.f_guid=cbs.f_stuguid
where cbs.f_classguid in ('8faf1339009c47cfb62aa83c4ed6ed4b')
order by tstu.f_code,ce.f_examname2
where cbs.f_classguid in ('8faf1339009c47cfb62aa83c4ed6ed4b')
and not exists(
select 1 from C_Exam
where F_TermGUID=ce.F_TermGUID and F_ExamTypeGUID=ce.F_ExamTypeGUID and F_GradeGUID=ce.F_GradeGUID and [sign]>ce.[sign]
)