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

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

好多题目啊 打半天

不过那么多分数 值了 呵呵

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

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

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

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

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