用SQL语言查询班上前5名学生成绩


用SQL语言查询班上前5名学生成绩

文章插图
【用SQL语言查询班上前5名学生成绩】--SQL ServerSelect top 5 * from Studentsorder by score desc--MySQLSelect * from StudentsOrder by score descLimit 5--OracleSelect * from StudentsWhere rownum