id_ , company_id_, company_ids_, company_name_, type_, road_segment_id_, road_segment_name_, budget_sum_, already_count_, already_metering_count_, ascription_year_, start_time_, end_time_, is_dele_, 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_, tenant_id_ SELECT a.id_, a.road_segment_id_, a.road_segment_name_, a.budget_sum_, a.already_count_, a.ascription_year_ FROM biz_budget a WHERE a.is_dele_ = '0' AND a.ascription_year_ = #{year}