– 1.查询student表中所有的记录SELECT * FROM student;
– 2.查询student表中所有记录的s_name,s_sex和s_class列
SELECT s_no,s_name,s_class FROM student;
– 3.查询教师所有的单位但是不重复的t_depart列
SELECT distinct (t_depart) FROM teacher;
– 4.查询score表中成绩在60-80之间所有的记录(sc_degree)
SELECT * FROM score WHERE sc_degree BETWEEN 61 AND 79;
SELECT * FROM score WHERE sc_degree < 80 AND sc_degree > 60 ;
– 5.查询score表中成绩为85, 86, 或者88的记录(sc_degree)
SELECT * FROM score WHERE sc_degree IN(85, 86, 88);
– 6.查询student表中’95031’班或者性别为’女’的同学记录
SELECT * FROM student WHERE s_class = '95031' OR s_sex = '女';
– 7.以class降序查询student表中所有的记录
SELECT * FROM student ORDER BY s_class desc;
– 8.以c_no升序.sc_degree降序插叙score表中所有的数据先以c_no进行升序,若c_no相同,则以sc_degree降序
SELECT * FROM score ORDER BY c_no ASC,sc_degree DESC;
– 9.查询’95031’班的学生人数