求解,数据库查询的面试题

2025-03-25 19:19:56
推荐回答(1个)
回答1:

a
create table s (学生 varchar2(20));
create table c (课程 varchar2(20));
create table sc (学生 varchar2(20), 课程 varchar2(20));

b
select * from s
where (select count(*) from sc where sc.学生 = s.学生) = (select count(*) from c)

b
select * from s
where (select count(*) from sc where sc.学生 = s.学生) >= 5