一个student 表 有以下字段 stuNo, stuName,math,english,chinses;
有以下数据,
insert into student(stuNo,stuName,math) values(1010,'张三',98);
insert into student(stuNo,stuName,english) values(1010,'张三',88);
insert into student(stuNo,stuName,chinses) values(1010,'张三',78);
insert into student(stuNo,stuName,math) values(1020,'李四,88);
insert into student(stuNo,stuName,english) values(1020,'李四',68);
insert into student(stuNo,stuName,chinses) values(1020,'李四',89);
写一条SQL 语句得到以下结果;
stuNo, stuName,math,english,chinses
1010 张三 98 88 78
1020 李四 88 68 89{{