首頁(yè) 猿問【求助】查詢學(xué)過(guò)學(xué)號(hào)為&ldquo...

【求助】查詢學(xué)過(guò)學(xué)號(hào)為“1”同學(xué)所有課程的其他同學(xué)學(xué)號(hào)和姓名（好難的）

MySQL

阿波羅的戰(zhàn)車 2018-07-18 10:18:13

查詢學(xué)過(guò)學(xué)號(hào)為“1”同學(xué)所有課程的其他同學(xué)學(xué)號(hào)和姓名

查看完整描述

1 回答

哈士奇WWW

TA貢獻(xiàn)1799條經(jīng)驗(yàn) 獲得超6個(gè)贊

SELECT stu.Sid, stu.Sname FROM Student stu INNER JOIN SC score2
ON (stu.Sid = score2.Sid) WHERE score2.Cid IN (
SELECT Cid FROM SC score WHERE score.Sid = '1' )
GROUP BY stu.Sid, stu.Sname
HAVING COUNT(score2.Cid) = (
SELECT COUNT(1) FROM SC score WHERE score.Sid = '1' ) AND stu.Sid <> '1'

反對(duì) 回復(fù) 2018-08-16