sql上机实验.doc
文本预览下载声明
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
显示全部