/*单表查询*/ select * from student2 where classname='计算机5班' /*连接查询*/ select score as 成绩,rank as 排名 from student3 as a join student2 as b on a.sno = b.sno where score='99'