排名

用户解题统计

过去一年提交了

勋章 ①金银铜：在竞赛中获得第一二三名；②好习惯：自然月10天提交；③里程碑：解决1/2/5/10/20/50/100/200题；④每周打卡挑战：完成每周5题，每年1月1日清零。

收藏

收藏日期 题目名称 解决状态
没有收藏的题目。

评论笔记

评论日期 题目名称 评论内容 站长评论
没有评论过的题目。

提交记录

提交日期 题目名称 提交代码
2026-03-07 分组与聚合函数（1）Money全都花在哪，GroupBy来查一查  
select mch_nm, sum(trx_amt) as sum_trx_amt
from cmb_usr_trx_rcd
 where usr_id=5201314520
 and trx_time regexp '2024'
 group by mch_nm
2026-03-07 条件过滤（3）Hour函数很给力，组合条件要仔细  
select * from cmb_usr_trx_rcd 
where
usr_id=5201314520
and
date(trx_time) between '2024-09-01' and '2024-09-30'
and
(hour(trx_time) between '22' and '24'
or
hour(trx_time) between '0' and '5')
2026-03-07 条件过滤（3）Hour函数很给力，组合条件要仔细  
select * from cmb_usr_trx_rcd 
where
usr_id=5201314520
and
date(trx_time) between '2024-09-01' and '2024-09-30'
and
(hour(trx_time) between '22' and '26')
and
(hour(trx_time) between '0' and '6')
2026-03-07 条件过滤（3）Hour函数很给力，组合条件要仔细  
select * from cmb_usr_trx_rcd 
where
usr_id=5201314520
and
date(trx_time) between '2024-09-01' and '2024-09-30'
and
(hour(trx_time) between '22' and '26')
and
(hour(trx_time) between '0' and '5')
2026-03-07 条件过滤（3）Hour函数很给力，组合条件要仔细  
select * from cmb_usr_trx_rcd 
where
usr_id=5201314520
and
date(trx_time) between '2024-09-01' and '2024-09-30'
and
(hour(trx_time) between '22' and '24')
and
(hour(trx_time) between '0' and '5')
2026-03-07 条件过滤（3）Hour函数很给力，组合条件要仔细  
select * from cmb_usr_trx_rcd 
where
usr_id=5201314520
and
date(trx_time) between '2024-09-01' and '2024-09-30'
and
(hour(trx_time) not between '22' and '24')
and
(hour(trx_time) not between '0' and '5')
2026-03-07 条件过滤（3）Hour函数很给力，组合条件要仔细  
select * from cmb_usr_trx_rcd 
where
usr_id=5201314520
and
date(trx_time) between '2024-09-01' and '2024-09-30'
and
(hour(trx_time) not between '6' and '21')
2026-03-07 条件过滤（3）Hour函数很给力，组合条件要仔细  
select * from cmb_usr_trx_rcd 
where
usr_id=5201314520
and
date(trx_time) between '2024-09-01' and '2024-09-30'
and
(hour(trx_time) not between '5' and '22')
2026-03-07 条件过滤（3）Hour函数很给力，组合条件要仔细  
select * from cmb_usr_trx_rcd 
where
usr_id=5201314520
and
date(trx_time) between '2024-09-01' and '2024-09-30'
and
hour(trx_time) not between '5' and '22'
2026-03-07 条件过滤（3）Hour函数很给力，组合条件要仔细  
select * from cmb_usr_trx_rcd 
where
usr_id=5201314520
and
date(trx_time) between '2024-09-01' and '2024-09-30'
and
hour(trx_time) between '22' and '5'
2026-03-07 条件过滤（2）半夜活动有猫腻，Hour函数给给力  
select *
from cmb_usr_trx_rcd
where usr_id=5201314520 
and (trx_time between '2024-09-01 00:00:00' and '2024-09-30 23:59:59')
and (trx_time regexp '0[1-5]:[0-9][0-9]:[0-9][0-9]$')
2026-03-07 条件过滤（2）半夜活动有猫腻，Hour函数给给力  
select *
from cmb_usr_trx_rcd
where usr_id=5201314520 
and (trx_time between '2024-09-01 01:00:00' and '2024-09-30 05:00:00')
2026-03-07 条件过滤（2）半夜活动有猫腻，Hour函数给给力  
select *
from cmb_usr_trx_rcd
where usr_id=5201314520 
and (trx_time between '2024-09-01 01:00:00' and '2024-09-01 05:00:00')
order by trx_time
2026-03-07 条件过滤（2）半夜活动有猫腻，Hour函数给给力  
select *
from cmb_usr_trx_rcd
where usr_id=5201314520 
and (trx_time between '2024-09-01 01:00:00' and '2024-09-01 05:00:00')
2026-03-07 条件过滤（2）半夜活动有猫腻，Hour函数给给力  
select *
from cmb_usr_trx_rcd
where usr_id=5201314520 
and (trx_time between '2024-09-01 01:00:00' and '2024-09-01 06:00:00')
order by trx_time
2026-03-07 条件过滤（2）半夜活动有猫腻，Hour函数给给力  
select *
from cmb_usr_trx_rcd
where usr_id=5201314520 
and (trx_time between '2024-09-01 01:00:00' and '2024-09-01 06:00:00')
2026-03-07 条件过滤（1）异地男友有异常，数分闺蜜来帮忙  
select * 
from cmb_usr_trx_rcd 
 where usr_id = 5201314520 
 and 
 (trx_time between '2024-09-01 00:00:00' and '2024-09-30 23:59:59')
 order by trx_time
2026-03-07 条件过滤（1）异地男友有异常，数分闺蜜来帮忙  
select * 
from cmb_usr_trx_rcd 
 where usr_id = 5201314520 
 and 
 (trx_time between '2024-09-01' and '2024-09-30')
 order by trx_time
2026-03-07 条件过滤（1）异地男友有异常，数分闺蜜来帮忙  
select * 
from cmb_usr_trx_rcd 
 where usr_id = 5201314520 
 and 
 (trx_time between '2024-09-01' and '2024-09-30')
2026-03-07 条件过滤（1）异地男友有异常，数分闺蜜来帮忙  
select * 
from cmb_usr_trx_rcd 
 where usr_id = 5201314520 
 and 
 (trx_time between '2024-09-01' and '20224-09-30')