ID_, YEAR_BUDGET_ID_, ASCRIPTION_YEAR_, ADD_TO_, EXPENDITURE_TYPE_, BUDGET_TYPE_, BUDGET_ITEM_, BUDGET_CONTENT, COMPANY_, QUANTITIES_, UNIT_PRICE_, TOTAL_PRICE_, REMARK_, CREATE_BY_, CREATE_NAME_, CREATE_ORG_NAME_, CREATE_COMPANY_ID_, CREATE_COMPANY_NAME_, CREATE_ORG_ID_, CREATE_TIME_, UPDATE_BY_, UPDATE_NAME_, UPDATE_COMPANY_NAME_, UPDATE_COMPANY_ID_, UPDATE_ORG_ID_, UPDATE_ORG_NAME_, UPDATE_TIME_, LAST_TIME_, IS_DELE_, VERSION_, TENANT_ID_,IMAGE_PROGRESS_,SORT_ SELECT SUM( TOTAL_PRICE_ ) FROM biz_year_budget_detailed WHERE ASCRIPTION_YEAR_ = #{year} AND YEAR_BUDGET_ID_ =#{yearBudgetId} SELECT b.*,( SELECT SUM( a.TOTAL_PRICE_ ) FROM biz_year_budget_detailed a ) AS "budgetSum" FROM biz_year_budget_detailed b ${ew.customSqlSegment} SELECT SUM( IMAGE_PROGRESS_ ) FROM biz_year_budget_detailed WHERE YEAR_BUDGET_ID_ = #{budgetId} and IS_DELE_ = '0'