Question

sql server 刚刚开始学习，找几题试试，求大神帮弄下这几题给个参考





Answer 1

2图①：select xuehao,xingming,zongxuefen from xsqk where suozaixi = '信息系'
2图②：select * from xsqk where zhuanye='计算机网络' and xinbie = '0'
2图③：select kechengid,kechengmingzi,jiaoshi,kaiketime from kc as a inner join xs_kc as b on a.xuehao = b.xuehao where 学期='第二学期' and 学期 = '第四学期'
2图④：select * from xsqk where dianhua like '%0772%'

3图①：insert into xs_kc values('201402','002',99,5)
3图②：update xs_kc set xuefen=10 where xuehao=201105

Answer 2

找几题试试，