写一个SQL: student(Sno, Sname, classId, grade )查出每个班成绩前三名的同学
标签：and name div from sid rom class bsp select
查看更多关于写一个SQL: student(Sno, Sname, classId, grade )查出每个的详细内容...
声明：本文来自网络，不代表【好得很程序员自学网】立场，转载请注明出处：http://haodehen.cn/did117933
写一个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
)
阅读：21次