sql练习题摘抄

1.查询Score表中成绩为85，86或88的记录。

select * from score where degree in (85,86,88);

 

2.以Class降序查询Student表的所有记录。

select * from student order by class desc;

 

3.以Cno升序、Degree降序查询Score表的所有记录。

select * from score ORDER BY cno asc,degree desc;

（desc:降序  asc:升序（默认升）)

 

4.查询“95031”班的学生人数。

select count(1) from student where class = '95031';