文档详情

sql上机实验.doc

发布:2017-12-12约1.38万字共6页下载文档
文本预览下载声明
1 select * from student where sex=男 2 select sno,grade from sc where cno=1 3 select sno,sname from student where year(csrq)1989 4 select sno,sname,sdept from student where sdept=信息系 and sex=女 5 select cno,ccredit from course where cname=数据库 6 select cno,cname from course where cpno=5 7 select * from student where year(csrq)=1990 and sdept=英语系 8 select * from student where (2010-year(csrq)21) and (sdept = 计算机系 or sdept = 信息系) 9 select sno,cno,grade from sc where (cno = 3 or cno = 4) 10 select cname,cpno,ccredit from course where cpno=0 and ccredit=2 1 SELECT sname,sdept, 2010-year(csrq) FROM student WHERE 2010-year(csrq)=20 AND 2010-year(csrq) =23; 2 SELECT DISTINCT sno FROM sc; 3 SELECT * FROM sc ORDER BY cno,grade DESC; 4 SELECT grade FROM sc WHERE cno=1 ORDER BY grade DESC; 5 SELECT sno,grade FROM sc WHERE cno=1 AND grade85; 6 SELECT * FROM student WHERE sname like 李%; 7 SELECT sdept,sex FROM student WHERE sname like 张_; 8 SELECT sname,sno FROM student WHERE sname like __军; 9 SELECT sname,sno FROM student WHERE sname not like 刘% AND sdept=信息系; 10 SELECT cname,ccredit FROM course WHERE ccredit3 AND cname like 数据%; SELECT sname,cname,grade FROM sc,course,student WHERE sc.sno=student.sno AND course.cno=sc.cno; 2 SELECT sname,cno,grade FROM sc,student WHERE cno=1 AND grade80 AND sc.sno=student.sno; 3 SELECT sname,cno,grade FROM sc,student WHERE cno 1 AND sex = 女 AND sc.sno=student.sno ORDER BY grade DESC; 4 SELECT sname,grade FROM sc,course,student WHERE cname=数据库 AND sex = 男 AND sc.sno=student.sno AND course.cno=sc.cno; 5 SELECT max(grade) as 最高成绩,min(grade) as 最低成绩,avg(grade) as 平均成绩 FROM sc,course WHERE sc.cno=course.cno and cname=数据库; 6 SELECT cno,sname,grade FROM student,sc WHERE student.sno=sc.sno and cno in (1,3); 7 SELECT sum(grade) as 总成绩,avg(grade) as 平均成绩 FROM student,sc 1 select sno,avg(grade) as 平均成绩 from sc grou
显示全部
相似文档