～葵花籽ル♀ SQL的作业题，答对送20积分

答案:5 悬赏:70 手机版

解决时间 2021-06-07 03:26

提问者网友：不要迷恋哥
2021-06-06 05:01

有人答对那问题的请来这里贴上你的答案

最佳答案

五星知识达人网友：人间朝暮
2021-06-06 05:39

好多题目啊打半天

不过那么多分数值了呵呵

1 select * from Student

2 select sno,sname from Student

3 select Sno,Sname,Sdept from Student

4 select Sname,GetYear()-Sage from Student --不确定

5 select Sno from Student,SC where Student.Sno=SC.Sno

6 select Sname from Student where Sdept='CS'

7 select Sname,Sage from Student where Sage<20

8 select Sno from SC where GRADE<60

9 select Sname,Sage,Sdept where Sage>=20 and Sage<=23

10 select Sname,Sage,Sdept where Sage<20 or Sage>23

11 select Sname,Ssex where Sdept='SC' or Sdept='MA' or Sdept='IS'

12 select * from Student where Sno='200215121'

13 select Sname,Sno,Ssex from Student where Sname like '刘%'

14 select Sname from Student where Sname like ‘欧阳%’

15 select Sname,Sno from Student where Sname like '%阳%'

16 select Sname from Student where Sname not like '刘%'

17 select Cno,Ccredit from Course where Cname='DB_Desigm'

18 select * from Course where Cname like 'DB_%'

19 select Sno,Cno from SC where Grade=null

20 select Sno,Cno from SC where Grade!=null

21 select Sname from Student where Sage<20 and Sdept='CS'

22 select Sno,Grade from SC where Cno=3 order by Grady desc

23 select * from Student group by Sdept order by Sno

全部回答

1楼网友：春色三分
2021-06-06 08:14

有人这么辛苦写了，我就不抢了，如果还没满意的话，我再来

2楼网友：持酒劝斜阳
2021-06-06 06:50

已经回答了一些，我第二讲有课，只能写这么多了，不好意思。

3楼网友：孤老序
2021-06-06 06:42

这分耀眼，这可惜现在没时间....考试你们怎么办啊？？

我现在在努力学好SQL，其实，好好学，并不难的，代码都是挺简单的，

用心做，找规律，会明白的..

4楼网友：佘樂
2021-06-06 05:48

什么问题么?不知道...

我要举报

如以上回答内容为低俗、色情、不良、暴力、侵权、涉及违法等信息，可以点下面链接进行举报！

点此我要举报以上问答信息