select (select max(name) from user where userid=work.userid) as 用户名,
count(1) as 总工作数,
sum(decode(endtime,null,1)) as 未完成,
sum(decode(endtime,null,null,1)) as 已完成,
sum(decode(endtime,null,null,(endtime-starttime)*24 )) as 工作时长
from work
group by userid
order by userid
starttime endtime 按date类型处理
count(1) as 总工作数,
sum(decode(endtime,null,1)) as 未完成,
sum(decode(endtime,null,null,1)) as 已完成,
sum(decode(endtime,null,null,(endtime-starttime)*24 )) as 工作时长
from work
group by userid
order by userid
starttime endtime 按date类型处理
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货