当前位置:网站首页>MySQL数据库 - 单表查询(三)
MySQL数据库 - 单表查询(三)
2022-04-23 19:28:00 【x 心 动】
第1关:对查询结果进行排序
USE School;
#请在此处添加实现代码
########## Begin ##########
########## 查询1班同学的所有信息以成绩降序的方式显示结果 ##########
select * from tb_score where class_id=1 order by score desc;
########## End ##########
第2关:分组查询
USE School;
#请在此处添加实现代码
########## Begin ##########
########## 对班级名称进行分组查询 ##########
select * from tb_class group by class_id;
########## End ##########
第3关:使用 LIMIT 限制查询结果的数量
USE School;
#请在此处添加实现代码
########## Begin ##########
########## 查询班级中第2名到第5名的学生信息 ##########
select * from tb_score order by score desc limit 1,4;
########## End ##########
版权声明
本文为[x 心 动]所创,转载请带上原文链接,感谢
https://blog.csdn.net/qq_45623072/article/details/124055804
边栏推荐
- SSDB Foundation
- Zero cost, zero foundation, build profitable film and television applet
- MFC获取本机IP(网络通讯时用得多)
- Deep learning -- Summary of Feature Engineering
- js获取本机ip地址
- Reflection on the performance of some OpenGL operations in the past
- openlayers 5.0 两种居中方式
- RuntimeError: Providing a bool or integral fill value without setting the optional `dtype` or `out`
- MFCC: Mel频率倒谱系数计算感知频率和实际频率转换
- MySQL syntax collation (2)
猜你喜欢
Kubernetes入门到精通-KtConnect(全称Kubernetes Toolkit Connect)是一款基于Kubernetes环境用于提高本地测试联调效率的小工具。
[报告] Microsoft :Application of deep learning methods in speech enhancement
MySQL syntax collation (3)
山大网安靶场实验平台项目-个人记录(五)
OpenHarmony开源开发者成长计划,寻找改变世界的开源新生力!
Lottery applet, mother no longer have to worry about who does the dishes (assign tasks), so easy
[report] Microsoft: application of deep learning methods in speech enhancement
Why is PostgreSQL about to surpass SQL Server?
深度分析数据恢复原理——那些数据可以恢复那些不可以数据恢复软件
Build intelligent garbage classification applet based on Zero
随机推荐
Is meituan, a profit-making company with zero foundation, hungry? Coupon CPS applet (with source code)
Openlayers 5.0 reload the map when the map container size changes
MySQL practical skills
White screen processing method of fulter startup page
HTTP cache - HTTP authoritative guide Chapter VII
SQL of contention for system time plus time in ocrale database
Translation of audio signal processing and coding: Preface
How to uninstall easyton
Go three ways to copy files
Openharmony open source developer growth plan, looking for new open source forces that change the world!
【h264】libvlc 老版本的 hevc h264 解析,帧率设定
山大网安靶场实验平台项目—个人记录(四)
考试系统进入试卷优化思路
Coordinate conversion WGS-84 to gcj-02 and gcj-02 to WGS-84
Transaction processing of SQL Server database
js获取本机ip地址
Thoughts on the optimization of examination papers in the examination system
Zero base to build profit taking away CPS platform official account
goroutine
[report] Microsoft: application of deep learning methods in speech enhancement