- 博客(2)
- 收藏
- 关注
原创 sql mark
# 查询" 01 "课程比" 02 "课程成绩高的学生的信息及课程分数 select student.*,a.score'C01',b.score'C02' from (select score ,SId from sc where sc.CId='01') as a,(select score ,SId from sc where sc.CId='02') as b,studen...
2019-06-26 14:16:54 416
原创 SQL mark
SQL 按天、周、月、季度、年汇总 工单量报表(by 日期,工单处理人,工单类型,SLA解决) // 天 select a.day,sum(a.new) as 'new',sum(a.close) as 'close',a.ServiceStaff_2,a.servicetype from( select cast(createtime as date) as day,count(...
2019-06-26 14:05:05 563
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人