多测师

 找回密码
 立即注册
搜索
热搜: 活动 交友 discuz
查看: 13|回复: 0

单表查询作业

[复制链接]

16

主题

16

帖子

82

积分

注册会员

Rank: 2

积分
82
发表于 2020-9-25 09:14:52 | 显示全部楼层 |阅读模式
一   select * from student2 where class=1832;
二   select class,chinese from student2 where class=1832 and chinese>80 and chinese<90;
三   select * from student where id limit 4,6;
四   select name,id from student2 where english=98 and math=77 group by class having class=1832;
五   select * from student2 where class=1832 order by chinese desc;
六   select name from student2 where class in(1832,1833) and chinese<80 and math<80;
七   select name,class from student2 where chinese is null;
八   select name from student2 where chinese<60;
九   select class,avg(math) from student2 group by class;
十   select class,sum(chinese) from student2 group by class;
十一   insert  into
十二   select name,age from student2 where chinese>70 and math>70 and english>70;
十三   select name,class from student2 where english>70 and chinese>60 and math>60;
十四   select class,count(*) from student2 group by class;
十五   select class,count(*) from student2 where math>80 group by class;
回复

使用道具 举报

您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

QQ|多测师软件培训|Archiver|手机版|小黑屋|duoceshi Inc. ( 16058051 )

GMT+8, 2020-10-24 22:48 , Processed in 0.085922 second(s), 21 queries .

Powered by Discuz! X3.2 Licensed

© 2001-2013 Comsenz Inc.

快速回复 返回顶部 返回列表