- 博客(1)
- 收藏
- 关注
RSS订阅原创 mysql sum case when then
with m as ( select YEARWEEK(t.dates,1) week, DATE_FORMAT(date_sub(t.dates,INTERVAL WEEKDAY(t.dates) - 6 DAY),'%Y%m%d') sunday,t.pipeline,COUNT(*) cases_of_customer from (SELECT c.pipeline, c.cases,left(c.date,10) dates,c.customers,min(c.id) FROM( sele...
2022-01-21 15:41:41
1039
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人