我的代码是这样的:
SELECT T.CNAME AS 课程名称,
(SELECT T.SNAME FROM T WHERE T.RO = 1) AS 第1名,
(SELECT T.SNAME FROM T WHERE T.RO = 2) AS 第2名,
(SELECT T.SNAME FROM T WHERE T.RO = 3) AS 第3名
FROM (SELECT C.CNAME, S.SNAME, RO.RO
FROM (SELECT SID,
CID,
ROW_NUMBER() OVER(PARTITION BY CID ORDER BY SCORE DESC) AS RO
FROM SCORE) RO,
COURSE C,
STUDENT S
WHERE RO.CID = C.CID
AND S.SID = RO.SID
AND C.CNAME IN ('企业管理', '马克思思想', '数据库')
ORDER BY RO.CID) T
但显示的结果为
有什么办法可以做到一行显示课程名称和成绩吗?