mysql求每个班级的最高分_SQL 如何查找一个表里，每个班级各个学科的最高分？...

```sql

-- Create table

create table CLASS

(

classno INTEGER not null,

classname NVARCHAR2(32)

);

-- Add comments to the columns

comment on column CLASS.classno

is '班级编号';

comment on column CLASS.classname

is '班级名称';

-- Create/Recreate primary, unique and foreign key constraints

alter table CLASS

add constraint PK_CLASS primary key (CLASSNO);

-- Create table

create table STUDENT

(

s# INTEGER not null,

sname NVARCHAR2(32),

sage INTEGER,

ssex NVARCHAR2(8),

classno INTEGER

);

-- Add comments to the columns

comment on column STUDENT.s#

is '学号';

comment on column STUDENT.sname

is '姓名';

comment on column STUDENT.sage

is '年龄';

comment on column STUDENT.ssex

is '性别';

comment on column STUDENT.classno

is '班级编号';

-- Create/Recreate primary, unique and foreign key constraints

alter table STUDENT

add constraint PK_STUDENT primary key (S#);

alter table STUDENT

add constraint FK_STUDENT_CLASS foreign key (CLASSNO)

references CLASS (CLASSNO);

-- Create table

create table TEACHER

(

t# INTEGER not null,

tname NVARCHAR2(16)

);

-- Add comments to the columns

comment on column TEACHER.t#

is '教师编号';

comment on column TEACHER.tname

is '教师姓名';