查询所用的表结构见https://blog.csdn.net/zjhbeautiful/article/details/108065336
SQL经典50题第9题正解
题目:查询和“ 01 “号的同学学习的课程完全相同的其他同学的信息
正确解答需用到group_concat()函数,代码如下:
select
*
from
student
where
sid in (
select
sid
from
sc
group by
sid
having
group_concat(cid ORDER BY cid) = (
select
group_concat(cid ORDER BY cid)