求大神解答，关于sql语句，感谢！！！

查询至少选修了 学号为2的学生选修的所有课程 的学生学号！！！求解
求用mysql select语句输出。。。。

SELECT u.number from test u RIGHT JOIN (SELECT t.* from test t where t.number=2) i on u.no=i.no GROUP BY u.number

可以拿去Navicat试试

SELECT u.number from test u RIGHT JOIN (SELECT t.* from test t where t.number=2) i on u.no=i.no GROUP BY u.number

SELECT u.number from test u RIGHT JOIN (SELECT t.* from test t where t.number=2) i on u.no=i.no GROUP BY u.number

select u.number from test u right join (select t.* from test t where t.number=2) i on u.no=i.no group by u.number