select TNO,TN from T where TN like '_伟%'
select TN from T where TNO='C5'
select T.TNO,T.TN,TC.CNO from T,TC where T.TNO=TC.TNO and T.TN='刘伟'
select TC.TNO,group by TC.CNO as ‘任课数’from TC,T where TC.TNO=T.TNO
and T.Dept='计算机' and T.TNO in (select TNO from TC group by CNO havingcount(*)>2)
selcet TNO,TN from T where Prof in (select Prof from T where TN='刘伟')
select x.TN as姓名,x.Sal as 教师工资, y.Sal as刘伟的工资from T as x,T as y
where x.Sal>y.Sal and y.TN='刘伟'
第四问不太确定
1.SELECT COUNT(DISTINCT(学号)) FROM SC 2.SELECT 姓名 FROM S,SC WHERE S.学号=SC.学号 AND S.学号=1号 3.SELECT S.学号,姓名,课程名,成绩 FROM S,SC,C WHERE S.学号=SC.学号 AND SC.课程号=C.课程 AND 课程号=1号 4.SELECT S.学号,姓名 FROM S,SC WHERE S.学号=SC.学号 AND SC.课程=‘人工智能’ 5.SELECT MAX(成绩) FROM S,SC WHERE S.学号=SC.学号 AND S.学号=1号 6.SELECT 学号,姓名 FROM S WHERE SUBSTRING(姓名,3,2)=’月’ 7.SELECT 课程号,COUNT(*) FROM C,SC WHERE C.课程号=SC.课程号 8.SELECT S.学号,姓名 FROM S,SC,C WHERE S.学号=SC.学号 AND SC.课程号=C.课程号 AND C.成绩>80 9.SELECT DISTINCT(省区) FROM S WHERE S.系别=‘物理’ 10.SELECT * FROM S ORDER BY 系别 ASC,年龄 DSC 11.SELECT AVG(成绩 ) FROM C WHERE 课程号=2号 12.SELECT 学号,姓名 FROM S WHERE SUBSTRING(姓名,3,2)=’阳’(1)select * from sales where qty between 1000 and 10000(2)select gname,price,type,qty from goods,sales where goods.g#=sales.g# and fact='青岛海尔集团' and s# in(select s# from shops where sname='北京东方大厦') (3)select g# from (select g#,max(a.aqty) from (select g#,AVG(QTY) as aqty from sales group by g#) as a group by g#) as b 本来这题用top 做简单、但是考虑到有销售量相同的、还是用上面这个 (4)delete from sales where qty is null (5)create view S_VIEW as select * from shops where addr like '南京路%'欢迎分享,转载请注明来源:内存溢出
评论列表(0条)