当前位置:网站首页>Query the size of the total points obtained in a certain time period to sort
Query the size of the total points obtained in a certain time period to sort
2022-08-09 04:02:00 【The seed of the sun】
Not long ago, the editor encountered a descending query of points obtained according to a certain time period. At first glance, it is a query method that combines aggregation functions and sorting. How to do it?Not much nonsense, look at the code
select a.UserId,a.RealName,sumspan>(b.Points) as TotalPoints from IntellManuSchool_UserInfo as ainner join IntellManuSchool_UserPoints as b on a.UserId=b.UserId where a.EnterpriseId=10and b.AddTime>='2022-05-01' and b.AddTime<='2022-06-01'group by a.UserId,a.RealNameorder by TotalPoints desc
group by first order by last
If you had one goal in life, what would it be?
Not long ago I watched "The King's Feast". I think Xiang Yu's failure was not due to his arrogance or God's will, but to his own goals. He never thought of unifying the world one day, andIt is to overthrow the Qin Dynasty; Liu Bang's success lies in the fact that his subordinates have long regarded Liu Bang as the chosen person, and this also just caters to his mind.
What kind of goal should you set in your life so that you can honor your ancestors and win happiness?
边栏推荐
猜你喜欢
5.索引优化实战
01| Data Type
旭日图更好地呈现数据的层次结构,细致划分各项数据
做现货白银前这些要诀应先记起来
Error detected while processing /home/test/.vim/plugin/visualmark.vim
【Redis底层解析】跳跃表
提升用户体验,给你的模态弹窗加个小细节
"The Sword Offer" Problem Solution - week1 (continuously updated)
医学影像分割系统综述Data preparation for artificial intelligence in medical imaging: A comprehensive guide ...
PhotoShop软件笔记
随机推荐
【Pyspark】udf使用入门
项目管理-挣值分析方法学习总结
单根k线图知识别以为自己都懂了
Swift3.0 sets the background color and text color of the status bar
5823. 字符串转化后的各位数字之和
【服务器数据恢复】Ext4文件系统fsck后mount不上并报错的数据修复案例
了解CV和RoboMaster视觉组(五)图像处理中使用的滤波器
器件可靠性与温度的关系
leetcode 5724. 绝对差值和
【平衡二叉搜索树】细撕AVL树的插入操作
sklearn(一)
给电脑重装系统后修改远程桌面端口的方法
VsCode如何使用国内镜像下载
松柏集(浮窗思)
项目中'说到做不到'的个人分析
SQL JOIN上的and
ffmpeg之H265解码
07.1 类的的补充
powershell 执行策略
leetcode 5709. 最大升序子数组和