算法题是LeetCode(6)整数反转 (简单)
SQL应该是用成绩表(grade)吧
* 学号(sid)
* 课程号(cid)
* 成绩(grade)
先查B的再查A的
select sid
from grade
where cid=‘A的课程号’
AND sid EXISTS(
select sid, cid
from grade
where cid=‘B的课程号’
)
或者 group by sid分组也行
SELECT sid
FROM grade
WHERE cid = ‘A’的课程号’
or cid = ‘B’的课程号
GROUP BY sid
HAVING COUNT(DISTINCT cid) = 2;
这面试官可能单纯因为你框架的八股没背 然后后面就开始拷打你了