SELECT settlement_date settlementDate, unique_identification uniqueIdentification, batch_id batchId, participant_id participantId, participant_name participantName, participant_type participantType, participant_code participantCode, administrative, credit_code creditCode, solidify_type solidifyType, involved_power_grid involvedPowerGrid, nature_enterprise natureEnterprise, phone, company_phone companyPhone, bank, account_name accountName, account, status, enter_time enterTime, left_time leftTime, is_market isMarket, participant_area_code participantAreaCode, trading_industry_type tradingIndustryType, enterprise_type enterpriseType, market_id marketId, mkt_account_number mktAccountNumber, mkt_account_name mktAccountName, gdj, city_burean cityBurean, ele_address eleAddress, account_voltage accountVoltage, electricity_type electricityType, file_update_time fileUpdateTime, industry_type industryType, hi_energy_consumption hiEnergyConsumption, installed_capacity installedCapacity, run_cap runCap, temporary_electric_flag temporaryElectricFlag, account_area_code accountAreaCode, account_status accountStatus, account_runstatus accountRunstatus, meter_id meterId, meter_code meterCode, meter_name meterName, meter_credit_code meterCreditCode, sbs_account_number sbsAccountNumber, sbs_account_name sbsAccountName, meter_area_code meterAreaCode, meter_status meterStatus, meter_runstatus meterRunstatus, meter_voltage meterVoltage, meter_electricity_type meterElectricityType, push_status pushStatus FROM mm_user_participant_day_hn where settlement_date Between '2023-04-01' and '2023-04-31' AND (solidify_type = '02' or solidify_type = '03');帮我优化一下性能
4万+
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
