SQL EXPLORER：Plan/Package 分析工具简介

版权申诉

SQL

107 浏览量更新于2024-07-14 收藏 651KB PPT 举报

身份认证购VIP最低享 7 折!

领优惠券(最高得80元）

资源详情

资源推荐

Overview - Analyze



Driven by set of expert rules



Generates detail and summary reports



By Plan, package or DBRM



Easy to understand database access path

information



SQL relative cost as CPU value



SQL text



Recommendations



In Context with database and system



Creates and stores unique historical snapshot

剩余63页未读，继续阅读

coe_load_sql_profile.sql

oracle数据库固定执行计划，经测试可用，需要两次输入sql_id，然后提示可选择的sql plan hash value，选择合适的一个即可。

ROUTE_PLAN_FAIL(解决方案).md

LEFT JOIN t_user ON CONCAT(t_user.company_code, t_user.employee_number) = order_management.order_manager_employee_code LEFT JOIN t_sbu sbu ON sbu.sbu_code = aggregation.sbu_code LEFT JOIN tb_0030032_dt_lm_department order_department ON order_department.tms_organization_code = order_management.office_group_code LEFT JOIN tb_0030032_dt_lm_department project_department ON project_department.tms_organization_code = project.project_office_group_code LEFT JOIN ( SELECT DISTINCT 1 AS request_flag, order_plan_id FROM t_hr_request_overview ) request_overview ON order_management.order_plan_id = request_overview.order_plan_id LEFT JOIN ( SELECT DISTINCT 1 AS employee_flag, contract_l1.entruster_order_plan_id AS order_plan_id FROM tb_0080332_dt_pc_inhouse_contract_order_plan contract_l1 LEFT JOIN tb_0080332_dt_pc_inhouse_contract_order_plan contract_l2 ON contract_l1.trustee_order_plan_id = contract_l2.entruster_order_plan_id LEFT JOIN t_order_plan_employee_detail detail ON contract_l1.trustee_order_plan_id = detail.order_plan_id OR contract_l2.trustee_order_plan_id = detail.order_plan_id UNION SELECT DISTINCT 1 AS employee_flag, order_plan_id FROM t_order_plan_employee_detail ) employee_detail ON order_management.order_plan_id = employee_detail.order_plan_id 翻译代码

ON order_management.order_plan_id = request_overview.order_plan_id LEFT JOIN ( SELECT DISTINCT 1 AS employee_flag, contract_l1.entruster_order_plan_id AS order_plan_id ...

IF EXISTS ( SELECT COUNT( 1 ) AS count FROM ( SELECT t822.order_plan_id, overview.order_plan_id AS ovid, overview.hr_request_number, overview.hr_request_title, overview.response_deadline, overview.hr_request_create_office_group_code, overview.update_datetime FROM t_hr_request_overview overview LEFT JOIN tb_0080022_dt_pc_order_management t822 ON overview.order_plan_id = t822.order_plan_id WHERE t822.order_plan_id = "#000000639201" ) select_count )THEN SELECT TRUE AS result; ELSE SELECT FALSE AS result END IF 修改成正确代码

```sql DECLARE @count INT; SELECT @count = COUNT(*) FROM ( SELECT t822.order_plan_id, overview.order_plan_id AS ovid, overview.hr_request_number, overview.hr_request_title, overview.response_...

帮我优化这段sql：SELECT asewo.code_s as code,asewo.order_type_s as orderType,asewo.equipment_name_s as equipmentName,asewo.executor_s as executor, asewo.plan_start_time_T as planStartTime,asewo.plan_finish_time_T as planFinishTime,asewo.tpm_key_s as tpmKey,asewo.shop_s as shop, asewo.line_S as line,asewo.actual_start_time_t as startTime,asewo.actual_finish_time_t as finishTime,asewo.executor_account_s as executorAccounts, asewo.source_type_s as sourceType,asewo.SOURCE_ORDER_S as sourceOrder,asewo.CREATION_TIME as creationTime FROM AT_AS_EM_Work_Order asewo WHERE to_char(asewo.plan_start_time_T,'yyyy_mm-dd hh24:mi') <= to_char(plan_finish_time_T,'yyyy_mm_dd hh24:mi') AND asewo.ORDER_STATUS_S='创建' AND asewo.executor_s='H007063' AND asewo.EQUIPMENT_NAME_S like '%机%' GROUP BY asewo.shop_s, asewo.line_S

修改后的 SQL 可以是这样的： ``` SELECT asewo.code_s as code, asewo.order_type_s as orderType, asewo.equipment_name_s as equipmentName, asewo.executor_s as executor, asewo.plan_start_time_T as ...

SELECT bs.sample_id, bs.item_id, bs.report_id, bs.order_no, bs.order_id, bs.order_business_type, bs.commission_date, bs.customer_name, bs.applicant, bs.phone, bs.receive_user_name, bs.contract_no, bs.special_requirements, bs.report_org_name, bs.report_org_address, bs.sample_name, bs.standard_instrument_name, bs.complete_day, bs.sample_remark AS remark, bs.standard_instrument_id, bs.sample_no, bs.factory_number, bs.item_name, /bs.item_quantity,/ bs.inspection_type, bs.mandatory_flag, bs.test_quantity, bs.sample_state, bs.current_site, bs.plan_complete_date, bs.affix, bs.ranges, bs.grade, bs.factory, bs.calibrat_point, bs.apply_dept, bs.specification, bs.final_fee, bs.service_type, CASE WHEN bs.actual_complete_date IS NOT NULL THEN DATEDIFF( bs.plan_complete_date, bs.actual_complete_date ) ELSE datediff( bs.plan_complete_date, now()) END AS surplus_days, bs.report_no, bs.is_report_back, bs.back_reason AS report_back_reason, bs.is_just_certificate, bs.report_state, bs.temper, bs.humidity, bs.test_result, bs.test_date, bs.next_test_date, bs.test_cycle, bs.test_address, bs.generate_time, bs.point_report_id, bs.is_merge, bs.circulation_flag, bs.item_proposal_fee AS proposal_fee, bs.change_price_reason, bs.test_user_name, bs.group_id, bs.group_name, bs.charging_num, bs.other_fee, bs.receivable_fee, bs.affix_quantity, bs.test_org, bs.out_org_order_no, bs.out_org_sample_no, bs.business_user_name, bs.pdf_path, bs.settlement_state, bs.result_describe, bsa.attach_id FROM view_sample_info bs JOIN bus_sample_report bsr ON bs.report_id = bsr.id JOIN bus_sample sa ON bsr.sample_id = sa.id JOIN bus_sample_attr bsa ON sa.id = bsa.id 根据bs.commission_date 进行排序最近的排上面 bs.commission_date

```sql SELECT bs.sample_id, bs.item_id, bs.report_id, bs.order_no, bs.order_id, bs.order_business_type, bs.commission_date, bs.customer_name, bs.applicant, bs.phone, bs.receive_user_name, ...

java.sql.SQLException: sql injection violation, syntax error: TODO : pos 872, line 15, column 43, token UNION : SELECT asewo.code_s as code,asewo.order_type_s as orderType,asewo.equipment_name_s as equipmentName,asewo.executor_s as executor, asewo.plan_start_time_T as planStartTime,asewo.plan_finish_time_T as planFinishTime,asewo.tpm_key_s as tpmKey,asewo.shop_s as shop, asewo.line_S as line,asewo.actual_start_time_t as startTime,asewo.actual_finish_time_t as finishTime,asewo.executor_account_s as executorAccounts, asewo.source_type_s as sourceType,asewo.SOURCE_ORDER_S as sourceOrder,asewo.CREATION_TIME as creationTime FROM AT_AS_EM_Work_Order asewo WHERE to_char(asewo.plan_start_time_T,'yyyy_mm-dd hh24:mi') <= to_char(plan_finish_time_T,'yyyy_mm_dd hh24:mi') AND asewo.ORDER_STATUS_S='创建' AND asewo.executor_s=? ORDER BY asewo.creation_time DESC Union All SELECT asewo.code_s as code,asewo.order_type_s as orderType,asewo.equipment_name_s as equipmentName,asewo.executor_s as executor, asewo.plan_start_time_T as planStartTime,asewo.plan_finish_time_T as planFinishTime,asewo.tpm_key_s as tpmKey,asewo.shop_s as shop, asewo.line_S as line,asewo.actual_start_time_t as startTime,asewo.actual_finish_time_t as finishTime,asewo.executor_account_s as executorAccounts, asewo.source_type_s as sourceType,asewo.SOURCE_ORDER_S as sourceOrder,asewo.CREATION_TIME as creationTime FROM AT_AS_EM_Work_Order asewo WHERE asewo.ORDER_STATUS_S='创建' AND asewo.executor_s=? ORDER BY asewo.creation_time DESC如何改

这段代码是一个SQL查询语句，其中包含了一个UNION操作符，因此可能存在SQL注入漏洞。如果要避免注入漏洞，可以使用参数化查询来构建SQL语句。具体来说，可以将查询中的变量使用占位符（如？）代替，然后在执行查询时...

SELECT tp.id as projectId,tp.project_name as projectName,tp.project_type as projectType, tipp.project_status as projectStatus FROM tzgl_project tp left join tzgl_investment_plan_project tipp on tipp.project_id = tp.id left join tzgl_investment_plan tip on tipp.plan_id = tip.id and tip.plan_year = 2023 and tip.plan_type in (1,3) where tp.id = '429158807596360069' and tip.is_deleted = 0 优化sql语句，实现当tipp.plan_type=1和tipp.plan_type=3都有值的时候，只查询到tipp.plan_type=3的一条值

LEFT JOIN tzgl_investment_plan tip ON tipp.plan_id = tip.id AND tip.plan_year = 2023 AND tip.plan_type IN (1,3) WHERE tp.id = '429158807596360069' AND tip.is_deleted = 0 ``` 这样可以避免查询出多条...

给下列程序添加注释： void DWAPlannerROS::reconfigureCB(DWAPlannerConfig &config, uint32_t level) { if (setup_ && config.restore_defaults) { config = default_config_; config.restore_defaults = false; } if ( ! setup_) { default_config_ = config; setup_ = true; } // update generic local planner params base_local_planner::LocalPlannerLimits limits; limits.max_vel_trans = config.max_vel_trans; limits.min_vel_trans = config.min_vel_trans; limits.max_vel_x = config.max_vel_x; limits.min_vel_x = config.min_vel_x; limits.max_vel_y = config.max_vel_y; limits.min_vel_y = config.min_vel_y; limits.max_vel_theta = config.max_vel_theta; limits.min_vel_theta = config.min_vel_theta; limits.acc_lim_x = config.acc_lim_x; limits.acc_lim_y = config.acc_lim_y; limits.acc_lim_theta = config.acc_lim_theta; limits.acc_lim_trans = config.acc_lim_trans; limits.xy_goal_tolerance = config.xy_goal_tolerance; limits.yaw_goal_tolerance = config.yaw_goal_tolerance; limits.prune_plan = config.prune_plan; limits.trans_stopped_vel = config.trans_stopped_vel; limits.theta_stopped_vel = config.theta_stopped_vel; planner_util_.reconfigureCB(limits, config.restore_defaults); // update dwa specific configuration dp_->reconfigure(config); }

limits.prune_plan = config.prune_plan; limits.trans_stopped_vel = config.trans_stopped_vel; limits.theta_stopped_vel = config.theta_stopped_vel; // Call reconfigureCB function of the planner_util...

改如何修正： <select id="getCurrentTask" resultType="com.sottop.sokonmobile.sokonmobile.qingdao.entity.AsEmWorkOrderEntity"> SELECT asewo.code_s as code,asewo.order_type_s as orderType,asewo.equipment_name_s as equipmentName,asewo.executor_s as executor, asewo.plan_start_time_T as planStartTime,asewo.plan_finish_time_T as planFinishTime,asewo.tpm_key_s as tpmKey,asewo.shop_s as shop, asewo.line_S as line,asewo.actual_start_time_t as startTime,asewo.actual_finish_time_t as finishTime,asewo.executor_account_s as executorAccounts, asewo.source_type_s as sourceType,asewo.SOURCE_ORDER_S as sourceOrder,asewo.CREATION_TIME as creationTime FROM AT_AS_EM_Work_Order asewo WHERE to_char(asewo.plan_start_time_T,'yyyy_mm-dd hh24:mi') <= to_char(plan_finish_time_T,'yyyy_mm_dd hh24:mi') AND asewo.ORDER_STATUS_S='创建' AND asewo.executor_s=#{executor} <if test="orderType!=null and orderType!=''"> AND asewo.order_type_s=#{orderType} </if> ORDER BY asewo.creation_time DESC Union All SELECT asewo.code_s as code,asewo.order_type_s as orderType,asewo.equipment_name_s as equipmentName,asewo.executor_s as executor, asewo.plan_start_time_T as planStartTime,asewo.plan_finish_time_T as planFinishTime,asewo.tpm_key_s as tpmKey,asewo.shop_s as shop, asewo.line_S as line,asewo.actual_start_time_t as startTime,asewo.actual_finish_time_t as finishTime,asewo.executor_account_s as executorAccounts, asewo.source_type_s as sourceType,asewo.SOURCE_ORDER_S as sourceOrder,asewo.CREATION_TIME as creationTime FROM AT_AS_EM_Work_Order asewo WHERE asewo.ORDER_STATUS_S='创建' AND asewo.executor_s=#{executor} <if test="orderType!=null and orderType!=''"> AND asewo.order_type_s=#{orderType} </if> ORDER BY asewo.creation_time DESC </select>

根据您提供的信息，似乎这个SQL语句存在一些问题，包括： 1. 在第一行的resultType中，应该使用全限定类名而非实体类名。 2. 在第6行的SQL语句中，应该使用小于等于（）而非HTML实体字符（<=）。 3. 在第18行...

SELECT bs.report_no, bs.sample_id, bs.test_id, bs.service_type, bs.sample_name, bs.total_fee, bs.receivable_fee, bs.sample_no, bs.ranges, bs.grade, bs.sample_remark AS remark, bs.factory, bs.item_name, bs.apply_dept, bs.specification, bs.factory_number, bs.calibrat_point, bs.mandatory_flag, bs.inspection_type, bs.report_org_name, bs.plan_complete_date, bs.standard_instrument_name, bs.bleeding_site_name, bs.arrive_date, DATEDIFF( bs.plan_complete_date, NOW()) AS surplus_days, bs.order_no, bs.order_type, bs.customer_name, bs.order_id, bs.business_type, bs.group_id, bs.group_name, bs.item_id, bs.is_merge, bs.pass_time, bs.audit_time, bs.report_id, bs.compile_time, bs.generate_time, bs.pass_user_name, bs.audit_user_name, bs.compile_user_name, bs.report_state, bs.is_just_certificate, bs.label_price, bs.labor_cost, bs.product_type, bs.batch_number, bs.original_number, bs.type_no, bs.template_id, bs.template_version, bs.standard_instrument_id, bs.standard_instrument_name, bs.report_query_code, bs.test_user_id, bs.test_user_name, bs.test_time, bs.review_user_id, bs.review_user_name, bs.review_time, bs.or_number, bs.test_result, bs.test_result_text, bs.test_date, bs.test_address, bs.result_value, bs.unit, bs.test_dept_id, bs.test_dept_name, bs.sample_mass, bs.form, bs.color, bs.clarity, bs.amplification_detection, bs.precious_metal, bs.remarks, bs.photo, bs.identifying_code, bs.diamond_quality, bs.hand_ring, bs.craft, bs.instrument_photo, bs.customer_item_basis, bs.quality_photo, bs.check_point, bs.check_code, bs.mass_unit, bs.manufacturer_name, bs.manufacturer_addr, bs.result_sample_describe AS sampleDescribe, bs.test_rule AS metalRuleIdsStr, bsa.attach_id FROM view_sample_info bs JOIN bus_sample_report bsr ON bs.report_id = bsr.id JOIN bus_sample sa ON bsr.sample_id = sa.id JOIN bus_sample_attr bsa ON sa.id = bsa.id 需要按照bs.report_no 的整数来从小到大进行排序

你可以使用以下SQL语句来按照bs.report_no的整数值从小到大进行排序： ```sql SELECT bs.report_no, bs.sample_id, bs.test_id, bs.service_type, bs.sample_name, bs.total_fee, bs.receivable_fee, bs....

SELECT DISTINCT c.ID AS id, c.NAME AS contName, c.CONTRACT_NO AS contractNo, c.INSTANCE_ID AS instanceId, c.UNDERTAKE_DEPT_ID AS remindDeptId, c.UNDERTAKE_DEPT_NAME AS sendDeptName, c.CREATE_USER_ID, c.CREATE_USER_NAME AS contractOpteraterName, c.PLAN_STATE AS planState, c.PLAN_STATE_NAME AS planStateName, aw.INSTANCE_ID AS inId, aw.CREATE_TIME AS sendTime FROM ( SELECT c.* FROM ( SELECT c.* FROM ( SELECT c.ORIGINAL_CONTRACT_ID, MAX(CREATE_TIME) CREATE_TIME FROM CONTRACT_DRAFT.C_CONTRACT_INFO c WHERE c.ORIGINAL_CONTRACT_ID IS NOT NULL AND c.ORIGINAL_CONTRACT_ID != '' GROUP BY c.ORIGINAL_CONTRACT_ID ) t LEFT JOIN CONTRACT_DRAFT.C_CONTRACT_INFO c ON t.ORIGINAL_CONTRACT_ID = c.ORIGINAL_CONTRACT_ID AND t.CREATE_TIME = c.CREATE_TIME UNION ALL SELECT c.* FROM CONTRACT_DRAFT.C_CONTRACT_INFO c WHERE ( c.ORIGINAL_CONTRACT_ID IS NULL OR c.ORIGINAL_CONTRACT_ID = '' ) AND c.ID NOT IN ( SELECT c.ORIGINAL_CONTRACT_ID FROM CONTRACT_DRAFT.C_CONTRACT_INFO c WHERE c.ORIGINAL_CONTRACT_ID IS NOT NULL AND c.ORIGINAL_CONTRACT_ID != '')) c WHERE c.deleted_flag = 0 AND c.BELONG = 1 AND sysdate > c.end_date AND c.plan_state IN (4100, 4110, 4120, 4200, 4210, 4220, 5100, 5110, 5120) ) c INNER JOIN (SELECT INSTANCE_ID,create_time,state FROM CONTRACT_DRAFT.C_ACTIVITY_WORKITEMS WHERE state = 'Waiting') aw ON c.INSTANCE_ID = aw.INSTANCE_ID LEFT JOIN (SELECT deleted_flag,CONT_ID FROM CONTRACT_DRAFT.C_GET_PAY_PLAN WHERE deleted_flag = 0 ) g ON c.ID = g.CONT_ID LEFT JOIN CONTRACT_DRAFT.C_OUR_ENTITY_INFO oe ON c.OUR_ENTITY_ID = oe.ID AND oe.DELETED_FLAG = 0 ORDER BY aw.CREATE_TIME DESC 优化

LEFT JOIN CONTRACT_DRAFT.C_GET_PAY_PLAN g ON c.ID = g.CONT_ID AND g.deleted_flag = 0 LEFT JOIN CONTRACT_DRAFT.C_OUR_ENTITY_INFO oe ON c.OUR_ENTITY_ID = oe.ID AND oe.DELETED_FLAG = 0 WHERE c.deleted_...

select ddp.sale_planid ,unnest(case when(ddp.plan_receiver_id is null or ddp.plan_receiver_id[1] is null) then ARRAY[-1]::integer[] else ddp.plan_receiver_id end) cabinet_rule_id_r from ( select dp.plan_receiver_id --unnest(case when dp.cabinet_rule_id is null or dp.cabinet_rule_id[1] is null then ARRAY[-1]::integer[] else dp.cabinet_rule_id end ) cabinet_rule_id_r ,unnest(case when (dp.next_plan_id is null or dp.next_plan_id[1] is null) then ARRAY[-1]::integer[] else dp.next_plan_id end) as sale_planid --销地计划 from ods.ods_durian_delivery_plan AS dp where dp.type='ORIGIN') ddpSQL纠错

这段 SQL 语句存在语法错误。应该将 `CASE` 表达式的 `THEN` 和 `ELSE` 子句中的 `ARRAY[-1]::integer[]` 改为 `ARRAY[-1]`，同时在 `FROM` 子句中给子查询指定一个别名。修改后的 SQL 语句如下： ``` SELECT ddp....

SELECT * FROM ( SELECT a.POLICY_NO AS businessNo, a.ENDORSE_SEQ_NO AS businessSerialNo, a.TOTAL_SERIAL_NO AS totalSerialNo, a.BILL_TYPE AS billType, a.ISSUE_COMPANY AS companyCode, a.PLAN_CCY AS currency, a.EXCHANGE_RATE AS exchangeRate, a.PLAN_FEE AS totalAmount, a.VAT AS taxAmount, a.BUSINESS_NO AS proposalNo, CONVERT(decimal(16, 2), round(a.PLAN_FEE * a.EXCHANGE_RATE, 2)) AS exchangeTotalAmount, CONVERT(decimal(16, 2), round(a.VAT * a.EXCHANGE_RATE, 2)) AS exchangeTaxAmount, 'P' AS certiType, (CASE a.VAT WHEN '0' THEN 'N' ELSE 'Y' END) AS taxExemptFlag, a.PAY_NO AS payNo, ( SELECT top 1 g.LOSS_NO FROM GPLOSSFEE g WHERE g.POLICY_NO = a.POLICY_NO) AS lossNo FROM GPPOLICYPLAN a LEFT JOIN ( SELECT t.POLICY_NO, t.BUSINESS_SEQNO, t.PAY_NO, t.FEE_TYPE_CODE, t.TOTAL_SERIAL_NO FROM GPINPUTVATINVOICEREL t, GPPOLICYPLAN b WHERE t.BUSINESS_NO = b.POLICY_NO AND t.BUSINESS_SEQNO = b.ENDORSE_SEQ_NO AND t.PAY_NO = b.PAY_NO AND t.FEE_TYPE_CODE = b.BILL_TYPE AND t.TOTAL_SERIAL_NO = b.TOTAL_SERIAL_NO) p ON a.POLICY_NO = p.POLICY_NO AND a.ENDORSE_SEQ_NO = p.BUSINESS_SEQNO AND a.PAY_NO = p.PAY_NO AND a.BILL_TYPE = p.FEE_TYPE_CODE AND a.TOTAL_SERIAL_NO = p.TOTAL_SERIAL_NO WHERE (a.PAY_NO != p.PAY_NO OR p.PAY_NO IS NULL) AND a.PLAN_FEE < 0 AND a.BILL_TYPE != 'R10' AND a.COMPANY_CODE IN ( '729021' , '729020' , '729023' , '729022' , '729000' , '729061' , '729060' , '729041' , '729040' , '729081' , '729080' , '729079' , '729010' , '729031' , '729078' , '729077' , '729011' , '729050' , '729072' , '729071' , '729074' , '729052' , '729030' , '729051' , '729073' , '729070' , '86' ) ) WHERE rownum <= 5 oracl怎么改写

这个SQL查询语句可以改写为以下形式： ``` SELECT * FROM ( SELECT a.POLICY_NO AS businessNo, a.ENDORSE_SEQ_NO AS businessSerialNo, a.TOTAL_SERIAL_NO AS totalSerialNo, a.BILL_TYPE AS billType, a....

#ifndef _PLANNER_MANAGER_H_ #define _PLANNER_MANAGER_H_ #include <stdlib.h> #include <bspline_opt/bspline_optimizer.h> #include <bspline_opt/uniform_bspline.h> #include <traj_utils/DataDisp.h> #include <plan_env/grid_map.h> #include <plan_env/obj_predic

其中包含了一些头文件的引用，如 bspline_opt/bspline_optimizer.h、bspline_opt/uniform_bspline.h、traj_utils/DataDisp.h、plan_env/grid_map.h 和 plan_env/obj_predic。这些头文件提供了一些函数和数据类型，...

帮我优化这个pgsql select info.pot_type_name,info.ttpw_addr as twlPortName,info.ttpw_addr_code as twlPortCode,info.tmr_material_name,info.ids --库存 ,(select sum(twl_leave_stock) from tms_whe_control where twl_material_id = any(STRING_TO_ARRAY(ids, ','))and twl_port_code=ttpw_addr_code and pot_type_name='合作港口') as twl_leave_stock from ( select port.pot_type_name,ttpw.ttpw_addr ,ttpw.ttpw_addr_code,tmrGroup.tmr_material_name, array_to_string( ARRAY( SELECT unnest(string_to_array(array_to_string(array_agg(distinct(tmr.tmr_id)),','), ',')) ), ',' ) ids from tms_transport_plan_work ttpw,tms_material_ref tmr,tms_material_ref tmrGroup,pub_ports port,tms_transport_plan plan where tmr.tmr_id=ttpw_tmr_id and tmr.parent_tmr_id=tmrGroup.tmr_id and port.pot_regcd=ttpw.ttpw_addr_code and port.pot_cnname=ttpw.ttpw_addr and plan.ttp_id=ttpw.ttpw_ttp_id and plan.ttp_waybill_status >0 AND ttpw.ttpw_plan_amount > 0 GROUP BY pot_type_name,ttpw_addr,ttpw_addr_code,tmrGroup.tmr_material_name ORDER BY ttpw_addr ) as info

这个 SQL 语句有一些可优化的地方，可以考虑以下几点： 1. 尽可能使用 JOIN 代替子查询。例如，第一个子查询中的 `pub_ports` 表可以通过 JOIN 进行连接。 2. 避免使用 `array_agg` 和 `unnest` 函数。这些函数...

SELECT contract_l1.trustee_order_plan_id AS trustee_order_plan_id_level1, contract_l2.trustee_order_plan_id AS trustee_order_plan_id_level2 FROM tb_0080332_dt_pc_inhouse_contract_order_plan contract_l1 LEFT JOIN tb_0080332_dt_pc_inhouse_contract_order_plan contract_l2 ON contract_l1.trustee_order_plan_id = contract_l2.entruster_order_plan_id WHERE contract_l1.entruster_order_plan_id = '#000000000001' ORDER BY contract_l1.trustee_order_plan_id 解释这段代码

这段代码是一个 SQL 查询语句，用于从两个表中获取数据并进行连接和筛选。下面是对代码的解释： 1. 第一行指定了查询的字段，这里包括了两个别名为 `trustee_order_plan_id_level1` 和 `trustee_order_plan_id_...

根据id删除该sql的查询结果 select * from t_project_disclose tpd where tpd.id in ( select tpd.id from t_project_disclose tpd where tpd.project_plan_id not in ( select opp.ID from t_project_disclose tpd join overhaul_project_plan opp on tpd.project_plan_id = opp.ID ) and tpd.version_id = 'd2576fc1e2be4258ac8b624b926cc44c');

根据您提供的 SQL 查询语句，可以使用以下 SQL 语句来根据 id 删除查询结果中的数据： ``` DELETE FROM t_project_disclose WHERE id IN ( SELECT tpd.id FROM t_project_disclose tpd WHERE tpd.project_plan_...

下面代码存在什么问题？ action_plan_filters = {'audit_id': audit.id} action_plans = objects.ActionPlan.list( self.context, filters=action_plan_filters, eager=True) if not action_plans: return # The last action_plan should be of type rollback and the execution is # complete while (action_plans[-1].strategy.name != 'rollback' or (action_plans[-1].strategy.name == 'rollback' and action_plans[-1].state in [ objects.action_plan.State.RECOMMENDED, objects.action_plan.State.PENDING, objects.action_plan.State.ONGOING])): LOG.info("audit %s waiting for rolled back", audit.uuid) time.sleep(WAIT_SECONDS) action_plans = objects.ActionPlan.list( self.context, filters=action_plan_filters, eager=True) LOG.info("audit %s already rolled back", audit.uuid)

objects.action_plan.State.RECOMMENDED, objects.action_plan.State.PENDING, objects.action_plan.State.ONGOING]): break LOG.info("audit %s waiting for rolled back", audit.uuid) time.sleep(WAIT_...

SELECT COUNT( * ) FROM ( SELECT t.* FROM ( SELECT p.* FROM package_channel_price_plan p a WHERE a.sys_default = 0 UNION SELECT c.* FROM package_commodity_main_info b LEFT JOIN package_channel_price_plan c ON b.plan_code = c.plan_code WHERE 1 = 1 AND b.commodity_code = '3323070713301825957052' ) AS t WHERE 1 = 1 AND t.plan_status = '1' ORDER BY t.updated_time DESC ) TOTAL 这个sql错在哪里

LEFT JOIN package_channel_price_plan c ON b.plan_code = c.plan_code WHERE 1 = 1 AND b.commodity_code = '3323070713301825957052' ) AS t WHERE 1 = 1 AND t.plan_status = '1' ORDER BY t.updated_...

Nico_Robin_

粉丝: 0
资源: 1864