写一个SQL: student(Sno, Sname, classId, grade )查出每个班成绩前三名的同学

SELECT * FROM student stu WHERE (     SELECT COUNT(*) FROM student      WHERE stu.classid=classid AND stu.grade >= grade      GROUP BY classid HAVING COUNT(*)<=3 )

写一个SQL: student(Sno, Sname, classId, grade )查出每个班成绩前三名的同学

标签：and   name   div   from   sid   rom   class   bsp   select