22,209
社区成员
发帖
与我相关
我的任务
分享
SELECT
'测试' AS 报考岗位,
Users.departname AS 部门,
tb_cjk.tb_cjk_jh AS 学号,
Users.username AS 姓名,
tb_cjk.tb_cjk_time AS 考试时间,
MAX ( CASE WHEN tb_cjk_typename = '数学' THEN tb_cjk.tb_cjk_cj END ) AS 数学,
MAX ( CASE WHEN tb_cjk_typename = '语文' THEN tb_cjk.tb_cjk_cj END ) AS 语文,
MAX ( CASE WHEN tb_cjk_typename = '英语' THEN tb_cjk.tb_cjk_cj END ) AS 英语
FROM
tb_cjk
LEFT OUTER JOIN Users ON tb_cjk.tb_cjk_jh = Users.userid
WHERE
( 1 = 1 )
GROUP BY
Users.username,
tb_cjk.tb_cjk_jh,
Users.departname,
Users.birth,
tb_cjk.tb_cjk_time
ORDER BY
CHARINDEX( Users.departname, '部门' ), 学号