12-09
12-09
12-09
12-09
12-09
12-09
12-09
12-09
12-09
12-09
12-09
12-09
ADADADADAD
mysql数据库 时间：2024-12-24 19:12:55
作者：文/会员上传
12-09
12-09
12-09
12-09
12-09
12-09
12-09
12-09
12-09
12-09
12-09
12-09
1.查询出每门课都大于 80 分的学生姓名createtabletest2(idintnotnullauto_increment,namevarchar(10),kechengvarchar(10),fenshuint,primarykey(id))insertintotest2(name
以下为本文的正文内容，内容仅供参考！本站为公益性网站，复制本文以及下载DOC文档全部免费。
1.查询出每门课都大于 80 分的学生姓名
createtabletest2(idintnotnullauto_increment,namevarchar(10),kechengvarchar(10),fenshuint,primarykey(id))insertintotest2(name,kecheng,fenshu)values('张三','语文',81);insertintotest2(name,kecheng,fenshu)values('张三','数学',75);insertintotest2(name,kecheng,fenshu)values('李四','语文',76);insertintotest2(name,kecheng,fenshu)values('李四','数学',90);insertintotest2(name,kecheng,fenshu)values('王五','语文',81);insertintotest2(name,kecheng,fenshu)values('王五','数学',100);insertintotest2(name,kecheng,fenshu)values('王五','英语',90);--(1)selectnamefromtest2groupbynamehavingmin(fenshu)>80;王五--(2)selectdistinctnamefromtest2wherenamenotin(selectdistinctnamefromtest2wherefenshu<=80)王五
11-20
11-19
11-20
11-20
11-20
11-19
11-20
11-20
11-19
11-20
11-19
11-19
11-19
11-19
11-19
11-19