sql语句
where in 在 一堆数据
WHERE S.sid in( SELECT sid //在子查询的结果中 找 匹配的 sid
FROM SC
GROUP BY SID
HAVING COUNT(CID)
<(
SELECT COUNT(Course.CID)
FROM Course )
)
SELECT * FROM user WHERE name LIKE ‘%我’
sql语句
where in 在 一堆数据
WHERE S.sid in( SELECT sid //在子查询的结果中 找 匹配的 sid
FROM SC
GROUP BY SID
HAVING COUNT(CID)
<(
SELECT COUNT(Course.CID)
FROM Course )
)
SELECT * FROM user WHERE name LIKE ‘%我’