当前位置:网站首页>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?
边栏推荐
猜你喜欢
随机推荐
了解CV和RoboMaster视觉组(五)参数自适应与稳健特征
static成员及代码块
30 norm
leetcode 33/81. 搜索旋转排序数组
OpenCV相机标定完全指南(有手就行)
32 Basic Statistics - Hypothesis Testing
松柏集(夜未央)
Swift3.0 sets the background color and text color of the status bar
31 基本统计概念
Win11一键重装系统后如何使用自带的故障检测修复功能
powershell 执行策略
union
了解CV和RoboMaster视觉组(五)运动建模与预测
剑指 Offer 56 - I. 数组中数字出现的次数
旭日图更好地呈现数据的层次结构,细致划分各项数据
leetcode 1805. 字符串中不同整数的数目
卷积神经网络模型训练——入门理解
全链路UI设计笔记
当IDEA罢工时
Kaggle(六)特征衍生技术 特征聚合









