SQL经典案例

查询每个班前三名

create table test_score
(
    CLASS VARCHAR(10),
    NAME  VARCHAR(10),
    SCORE INTEGER
);

select class, name, score
from test_score a
where (select count(*) from test_score where class = a.class and a.score < score) < 3;