<select id="getAllWorkHour" parameterType="com.walmart.aloha.productmanage.entity.param.ParamWorkHours" resultType="com.walmart.aloha.productmanage.entity.result.ResultWorkHourExport"> SELECT work_hours.domain, work_hours.project_id, work_hours.project_name, work_hours.pmName, work_hours.hour_status as status, reso_allo.work_type, tu.english_name as name, work_hours.user_id, work_hours.work_date, work_hours.workhours as hours, work_hours.pm_user_id, work_hours.sap_id, tu.user_type, tu.chinese_name, tu.domain, tu.role, ROW_NUMBER () OVER ( PARTITION BY work_hours.project_id, work_hours.work_date, work_hours.user_id ORDER BY work_hours.project_id DESC ) theRow FROM ( SELECT twh.project_id, twh.user_id, twh.hour_status , twh.work_date , tu.english_name AS pmName, tp.project_name , tp.pm_user_id, tp.sap_id, tp.dom
SQL记录2
最新推荐文章于 2023-04-20 14:41:58 发布
![](https://img-home.csdnimg.cn/images/20240711042549.png)