1、#查询语文成绩大于英语成绩的学号姓名分数
create table stu
(
id int,
name varchar(20),
subject varchar(20),
score double
)
insert into stu values(1,'jack','cn',100);
insert into stu values(1,'jack','en',90);
insert into stu values(2,'rose','cn',70);
insert into stu values(2,'rose','en',90);
insert into stu values(3,'tony','cn',80);
insert into stu values(3,'tony','en',96);
cn:语文,en:英语
#查询语文成绩大于英语成绩的学号姓名分数
方式1:
#-----1:
select a.id,a.name,a.score from
(select id,name,score from stu where subject="cn") as a,
(select id,name,score from stu where subject="en") as b
where a.id