需要根据月份和年份计算工作量（使用更新的requiredbytime列）

本文介绍了需要根据月份和年份计算工作量（使用更新的requiredbytime列）的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述 我有列workordercurid，requiredbytime，ODS_Start_date，instanceid 我需要有多少workordercurid根据ods_start_date和instanceid更新/修改requiredbytime。 这里Workorderccurid是唯一的栏目 选择WorkorderCurID，count（RequiredByDtime）RequiredByDtime，CreateDtime from（ select * from DMSWEB .ODS_RECWorkOrderHeader（nolock））一个组由WorkorderCurID，CreateDtime 有计数（RequiredByDtime）> 1 由CreateDtime订购 我尝试过： 选择WorkorderCurID，count（RequiredByDtime）RequiredByDtime ，CreateDtime from（ select * from DMSWEB.ODS_RECWorkOrderHeader（nolock）） group by WorkorderCurID，CreateDtime have count（RequiredByDtime）> 1 order by CreateDtime 解决方案 i have columns workordercurid,requiredbytime ,ODS_Start_date,instanceidI need how many workordercurid's having updated/modified requiredbytime based on ods_start_date and instanceid.Here Workorderccurid is unique columnselect WorkorderCurID,count(RequiredByDtime) RequiredByDtime,CreateDtime from (select * from DMSWEB.ODS_RECWorkOrderHeader (nolock))agroup by WorkorderCurID,CreateDtimehaving count(RequiredByDtime)>1order by CreateDtimeWhat I have tried:select WorkorderCurID,count(RequiredByDtime) RequiredByDtime,CreateDtime from (select * from DMSWEB.ODS_RECWorkOrderHeader (nolock))agroup by WorkorderCurID,CreateDtimehaving count(RequiredByDtime)>1order by CreateDtime 解决方案 这篇关于需要根据月份和年份计算工作量（使用更新的requiredbytime列）的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！