在课程分数表course中,怎么查询出总分排在班里第二到第四名的同学呢?
建表语句
create table course
(
course_id int auto_increment primary key,
c_name varchar(10) not null,
c_kemu varchar(10) not null,
c_score int(3) not null
);
INSERT INTO course VALUES (‘1’, ‘小明’,‘语文’, ‘66’);
INSERT INTO course VALUES (‘2’, ‘晓东’,‘语文’, ‘79’);
INSERT INTO course VALUES (‘3’, ‘小曾’,‘语文’, ‘93’);
INSERT INTO course VALUES (‘4’, ‘小官’,‘语文’, ‘75’);
INSERT INTO course VALUES (‘5’, ‘老王’,‘语文’, ‘98’);
INSERT INTO course VALUES (‘6’, ‘老杨’,‘语文’, ‘58’);
INSERT INTO course VALUES (‘7’, ‘老杨’,‘数学’, ‘100’);
INSERT INTO course VALUES (‘8’, ‘老王’,‘数学’, ‘55’);
INSERT INTO course VALUES (‘9’, ‘小官’,‘数学’, ‘44’);
INSERT INTO course VALUES (‘10’, ‘小曾’,‘数学’, ‘77’);
INSERT INTO course VALUES (‘11’, ‘晓东’,‘数学’, ‘99’);
INSERT INTO course VALUES (‘12’, ‘小明’,‘数学’, ‘88’);
mysql实现 使用limit
oracle实现 不能用top,使用排序order by 和 row_number()配合使用