- 求大神解答，关于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
-
- Sy1110011tem 谢谢大神！
- 大约 2 年之前 回复
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
