– 查询没有学全所有课程的同学的信息
SELECT
st.*
FROM student st
LEFT JOIN score sc
ON st.s_id=sc.s_id
GROUP BY sc.s_id
HAVING COUNT(*)<(
SELECT
COUNT(*)
FROM course);
– 查询没有学全所有课程的同学的信息
SELECT
st.*
FROM student st
LEFT JOIN score sc
ON st.s_id=sc.s_id
GROUP BY sc.s_id
HAVING COUNT(*)<(
SELECT
COUNT(*)
FROM course);