写出标准SQL语句
发布网友
发布时间：2022-04-25 15:54
共1个回答
热心网友
时间：2022-04-07 21:30
1、select distinct s.sname
from s
left join sc on s.sno = sc.sno
left join c on sc.cno = c.cno
where cteacher <> 'liming'
2、select s.sname
from s
inner join sc on s.sno = sc.sno
where sc.scgrade < 60
group by s.sname
having count(s.sno)>2
3、select s.sname
from s
inner join sc on s.sno = sc.sno
where sc.cno in (1,2)
