Shulou(Shulou.com)06/01 Report--

1. Find out the names of students whose scores are greater than 80 in each course.

Create table test2 (id int not null auto_increment,name varchar (10), kecheng varchar (10), fenshu int,primary key (id)) insert into test2 (name,kecheng,fenshu) values ('Zhang San', 'Chinese', 81); insert into test2 (name,kecheng,fenshu) values ('Zhang San', 'Mathematics', 75); insert into test2 (name,kecheng,fenshu) values ('Li Si', 'Chinese', 76) Insert into test2 (name,kecheng,fenshu) values (Li Si, Mathematics, 90); insert into test2 (name,kecheng,fenshu) values (Wang Wu, Chinese, 81); insert into test2 (name,kecheng,fenshu) values (Wang Wu, Mathematics, 100); insert into test2 (name,kecheng,fenshu) values (Wang Wu, English, 90);-(1) select namefrom test2 group by namehaving min (fenshu) > 80 Wang Wu-(2) select distinct name from test2 where name not in (select distinct name from test2 where fenshu

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.