1)查询STUDENT表中所有的信息
SELECT * FROM STUDENT
2)查询TEACHER表中教师的编号和姓名
SELECT TNO AS 编号,tn AS 姓名 FROM teacher 3)查询学生的新成绩,每个人分数加5分SELECT * FROM SC
SCORE+5
4)查询STUDENT中的性别,并且重复值只显示一次SELECT DISTINCT SEX AS 性别 FROM STUDENT 5)查询年龄小于20岁的学生的姓名
SELECT SN AS 姓名 FROM STUDENT
WHERE age<20
6)对学生选课的成绩进行降序排列
SELECT * FROM SC
ORDER BY score DESC
7)查询姓名为张彬并且是计算机系的学生信息SELECT * FROM student
WHERE sn='张彬' AND dept='计算机'
8)查询学生表中考试成绩排列前三的学生信息SELECT * FROM SC
ORDER BY score DESC
9)查询考试成绩不及格的学生的姓名
SELECT DISTINCT sn AS 姓名 FROM SC,STUDENT WHERE score<60 AND SC.sno=student.sno
10)查询考试成绩优秀的学生姓名
SELECT DISTINCT sn AS 姓名 FROM SC,STUDENT WHERE score>80 AND SC.sno=student.sno
11)查询计算机系的女生的所有信息
SELECT * FROM student