MS Access：汇总时间大于24小时的查询再次从1重新开始

纸船承重•2022-12-16•随笔•阅读29

我希望此SQL查询有帮助：

SELECt T.UID,       CSTR(total_hours      + INT(total_min / 60))      + ":"      + CSTR(total_min Mod 60) as resultFROM    (SELECt UID, SUM(HOUR(TH.time_elapsed)) AS total_hours, SUM(MINUTE(TH.time_elapsed)) AS total_min    FROM trans_hist AS TH    GROUP BY UID) AS T

欢迎分享，转载请注明来源：内存溢出

原文地址:https://54852.com/zaji/5649743.html