1、查询学生表中学生成绩大于90的前三名
sql server查询的语句 select top 3 student.name,student.score from student order by student.score desc;
mysql的查询语句 select student.name,student.score from student order by student.score desc limit 3;
1、查询学生表中学生成绩大于90的前三名
sql server查询的语句 select top 3 student.name,student.score from student order by student.score desc;
mysql的查询语句 select student.name,student.score from student order by student.score desc limit 3;