少一个学号字段 select 学号 from where 课程号=101 or 课程号=102 group by 学号 having count(学号)=2
少一个学号字段, select 学号 from where 课程号=101 or 课程号=102 group by 学号 having count(学号)=2
少一个学号字段, select 学号 from where 课程号=101 or 课程号=102 group by 学号 having count(学号)=2 谢谢小鱼,我想知道用嵌套如何实现这个结果?
select 学号 from xs_kc where 课程号=101 and 学好 in(select 学号 from xs_kc where 课程号=102)
select stu.姓名 from stu.suject, where stu.学号 = suject.学号 and suject.代号 = .代号 and exists(select * from suject where 代号 = '101' or 代号 = '102' having count(*)>1) 晕 这样写似乎很笨
改进一下: select 姓名 from stu where 学号 in (select 学号 from suject where 代号 = '101' or 代号 = '102' having count(*)>1)
select 学号
from
where 课程号=101 or 课程号=102
group by 学号
having count(学号)=2
select 学号
from
where 课程号=101 or 课程号=102
group by 学号
having count(学号)=2
select 学号
from
where 课程号=101 or 课程号=102
group by 学号
having count(学号)=2
谢谢小鱼,我想知道用嵌套如何实现这个结果?
from xs_kc
where 课程号=101
and 学好 in(select 学号
from xs_kc
where 课程号=102)
where stu.学号 = suject.学号 and suject.代号 = .代号
and exists(select * from suject where 代号 = '101' or 代号 = '102' having count(*)>1)
晕 这样写似乎很笨
select 姓名 from stu where 学号 in
(select 学号 from suject where 代号 = '101' or 代号 = '102' having count(*)>1)