最大时间max

最新推荐文章于 2024-11-01 14:48:20 发布

删除没备份的痛

最新推荐文章于 2024-11-01 14:48:20 发布

阅读量263

点赞数

分类专栏： Sql Server 文章标签： java

本文链接：https://blog.csdn.net/qq_41995845/article/details/124616766

版权

Sql Server 专栏收录该内容

16 篇文章 0 订阅

订阅专栏

这篇内容涉及水利工程设施的损坏情况，包括病害类型、修复级别、扣分标准、修复量化指标等详细信息。通过对设施的深度分析，讨论了修复时效、扣分标准和行政区域划分等关键要素，为水利工程的管理和维护提供了数据支持。

摘要由CSDN通过智能技术生成

select d.yhdydm, d.id,concat(df1.type_name,'病害') damZy,dtype.damType, d.patrol_type_name damGrade,d.patrol_type_code,d.lsbh,ta.area_name sspq,d.dam_sources,d.add_time,d.user_name, d.node_name statusname,d.fac_name_new fac_name,d.device_type_name,d.fac_direction_name,d.dam_position, dtype.name largeType,d.damname smallType,d.dam_long,d.dam_width,d.dam_deep,d.damunitname,d.dam_from_name,d.isurgent,d.node_update_time,d.dealsug,d.original_lon,d.original_lat, dcd.pipeDredge '修复量化2', 	dc1.DAMDETAIL '修复量化',
	dc1.DAMUNITNAME '修复量化单位',
  dcd.pipeDredgeUnit '修复量化2单位',   dcd.wellAndRainGrateCleaning '修复量化3',   dcd.wellAndRainGrateCleaningUnit '修复量化3单位',   dcd.clearingSilt '修复量化4',   dcd.clearingSiltUnit '修复量化4单位',d.xxProjectId,  d.pointsDeducted 超时扣分,   d.deductionStandard  修复时效,   d.score 当前扣分数,  zcdfc.name 行政区划,   dtype.repairTimeDescription 修复时效说明,   dtype.deductionStandardDescription 扣分标准说明,   vr.planBh,d.remark,d.PRODEPARTMENT  from damage d  left join  view_RepairProject vr on d.xxProjectId=vr.id left join (select dti.name,dd.code,dd.damType,ddt.repairTimeDescription,ddt.deductionStandardDescription from damagetypeinfo dti inner join damDaily dd on dd.pcode=dti.code and dti.operationStatue=0 left join     DamDailyTimeliness ddt on ddt.pCode=dd.CODE) dtype on d.damcode=dtype.code LEFT JOIN damageLog t8 ON t8.pid = d.id  AND t8.czzt = '修复'  AND t8.czsj = ( SELECT max( czsj ) FROM damageLog log2 WHERE log2.pid = d.id AND log2.czzt = '修复' ) LEFT JOIN DamageComplete dc1 ON dc1.pid = t8.pid  AND dc1.ADD_TIME = t8.CZSJ   left JOIN damageCompleteDetail dcd ON dc1.id = dcd.pid  left join T_area ta on d.sspq=ta.id left join dfccode df1 on df1.typeid='1010' and df1.TYPE_CODE=d.fac_id  left join zc_dfccode zcdfc on ta.AREA_ADMIN_CODE = zcdfc.code where d.isdelete='0'