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

font_select.zip_font_select.zip

请简化sql: select d.document_id , d.workflow_order_id,e.handle_result, d.workflow_id ,d.process_id -- ,e.workflow_id as workflow_id2 from (select doc.document_id , wo.workflow_order_id,wo.workflow_id,doc.process_id from document doc inner join workflow_order wo on doc.document_id = wo.object_id where doc.document_id = 1476093058673315842 and wo.workflow_id in( SELECT CASE WHEN process_id IN (1, 2) THEN 1470275488528011266 WHEN process_id IN (3, 4) THEN 1470275525786034178 END AS workflow_id FROM document WHERE document_id = 1476093058673315842 ) and wo.status != 3 )as d inner join (select wo.workflow_order_id,wr.handle_result,wr.workflow_id from workflow_record wr inner join workflow_order wo on wo.workflow_order_id = wr.workflow_order_id where wo.workflow_order_id in ( select wo.workflow_order_id from document doc inner join workflow_order wo on doc.document_id = wo.object_id where doc.document_id = 1476093058673315842 and wo.workflow_id in( SELECT CASE WHEN process_id IN (1, 2) THEN 1470275488528011266 WHEN process_id IN (3, 4) THEN 1470275525786034178 END AS workflow_id FROM document WHERE document_id = 1476093058673315842 ) and wo.status != 3 ) ) as e on d.workflow_order_id = e.workflow_order_id ;

SELECT d.document_id, d.workflow_order_id, e.handle_result, d.workflow_id, d.process_id FROM ( SELECT doc.document_id, wo.workflow_order_id, wo.workflow_id, doc.process_id FROM document doc INNER ...

编写存储过程 SELECT a.order_id, a.done_date, a.cust_id, a.subscriber_ins_id, a.access_num, c.dev_id, c.dev_name, c.corp_org, c.company_name, c.department_code, c.department_name, c.remarks FROM JOUR1.Om_Subscriber_202301 a LEFT JOIN JOUR1.om_order_202301 b ON a.order_id = b.order_id LEFT JOIN params1.sec_developer c ON b.dev_id = c.dev_id UNION ALL SELECT a.order_id, a.done_date, a.cust_id, a.subscriber_ins_id, a.access_num, c.dev_id, c.dev_name, c.corp_org, c.company_name, c.department_code, c.department_name, c.remarks FROM JOUR1.Om_Subscriber_202302 a LEFT JOIN JOUR1.om_order_202302 b ON a.order_id = b.order_id LEFT JOIN params1.sec_developer c ON b.dev_id = c.dev_id UNION ALL SELECT a.order_id, a.done_date, a.cust_id, a.subscriber_ins_id, a.access_num, c.dev_id, c.dev_name, c.corp_org, c.company_name, c.department_code, c.department_name, c.remarks FROM JOUR1.Om_Subscriber_202303 a LEFT JOIN JOUR1.om_order_202303 b ON a.order_id = b.order_id LEFT JOIN params1.sec_developer c ON b.dev_id = c.dev_id UNION ALL SELECT a.order_id, a.done_date, a.cust_id, a.subscriber_ins_id, a.access_num, c.dev_id, c.dev_name, c.corp_org, c.company_name, c.department_code, c.department_name, c.remarks FROM JOUR1.Om_Subscriber_202304 a LEFT JOIN JOUR1.om_order_202304 b ON a.order_id = b.order_id LEFT JOIN params1.sec_developer c ON b.dev_id = c.dev_id

SELECT a.order_id, a.done_date, a.cust_id, a.subscriber_ins_id, a.access_num, c.dev_id, c.dev_name, c.corp_org, c.company_name, c.department_code, c.department_name, c.remarks FROM JOUR1....

select o.order_num,o.start_time,o.total,bk.book_name,bk.book_price,od.num,od.total from order o inner join order_detail od on o.order_id=od.order_id where o.user_id=1008611 inner join book bk on od.book_id=bk.book_id;

SELECT o.order_num, o.start_time, o.total, bk.book_name, bk.book_price, od.num, od.total FROM order o INNER JOIN order_detail od ON o.order_id = od.order_id INNER JOIN book bk ON od.book_id = bk....

SELECT K.LOG_TIME ,COUNT(K.USER_ID) AS 当天的新增用户数 ,COUNT(B.USER_ID) AS 1 日留存率 ,COUNT(C.USER_ID) AS 7 日留存率 ,COUNT(D.USER_ID) AS 30 日留存率 FROM ( SELECT A.USER_ID ,A.LOG_TIME FROM TAB1 A GROUP BY A.USER_ID,A.LOG_TIME ) K LEFT JOIN (SELECT A.USER_ID ,A.LOG_TIME FROM TAB1 A GROUP BY A.USER_ID,A.LOG_TIME ) B ON B.USER_ID = K.USER_ID AND B.LOG_TIME = K.LOG_TIME + 1 LEFT JOIN (SELECT A.USER_ID ,A.LOG_TIME FROM TAB1 A GROUP BY A.USER_ID,A.LOG_TIME) C ON C.USER_ID = K.USER_ID AND C.LOG_TIME = K.LOG_TIME + 6 LEFT JOIN (SELECT A.USER_ID ,A.LOG_TIME FROM TAB1 A GROUP BY A.USER_ID,A.LOG_TIME ) D ON D.USER_ID = K.USER_ID AND D.LOG_TIME = K.LOG_TIME + 29 WHERE K.LOG_TIME = DATE'2019-05-01' GROUP BY K.LOG_TIME ORDER BY K.LOG_TIME ; 这句sql是什么意思

ON B.USER_ID = K.USER_ID AND B.LOG_TIME = K.LOG_TIME + 1 LEFT JOIN (SELECT A.USER_ID, A.LOG_TIME FROM TAB1 A GROUP BY A.USER_ID, A.LOG_TIME) C ON C.USER_ID = K.USER_ID AND C.LOG_TIME...

SELECT t1.supplier_id, t1.ky_count, t1.ky_amount, IFNULL(t2.ky_refund_count,0) as ky_refund_count, IFNULL(t2.ky_refund_amount,0) as ky_refund_amount FROM ( SELECT a.supplier_id, count( DISTINCT c.order_no ) AS ky_count, SUM( IFNULL( c.record_amount, 0 )) / 100 AS ky_amount FROM settle_order a INNER JOIN settle_order_receipt b ON a.order_id = b.order_id INNER JOIN cash_withdrawal_record c ON b.third_trade_no = c.order_no WHERE a.is_del = 0 AND a.order_time >= '2023-05-28 00:00:00' AND a.order_time < '2023-05-29 00:00:00' AND a.order_type in (70,75) AND a.supplier_id IN (78,63,58,57,64,72,71,74,83,77,70,69,67,82,65,87,73,59,66,60,86,85,79,80,84,90) AND b.channel_code = 61 AND c.con_bank_account_no IN ( 247, 325 ) AND c.record_status = 1 AND c.record_time > '2023-05-01 00:00:00' GROUP BY a.supplier_id ) t1 LEFT JOIN ( SELECT a.supplier_id, count( DISTINCT b.order_no ) AS ky_refund_count, SUM( IFNULL( b.record_amount, 0 )) / 100 AS ky_refund_amount FROM settle_order_refund a INNER JOIN cash_withdrawal_record b ON a.third_refund_id = b.order_no WHERE a.is_del = 0 AND a.order_type in (70,75) AND a.apply_time >= '2023-05-28 00:00:00' AND a.apply_time < '2023-05-29 00:00:00' AND a.supplier_id IN (78,63,58,57,64,72,71,74,83,77,70,69,67,82,65,87,73,59,66,60,86,85,79,80,84,90) AND a.channel_code = 61 AND b.con_bank_account_no IN ( 247, 325 ) AND b.record_status = 5 AND b.record_time > '2023-05-01 00:00:00' GROUP BY a.supplier_id ) t2 ON t1.supplier_id = t2.supplier_id order by t1.supplier_id asc

WHERE c.third_refund_id = b.order_no AND c.is_del = 0 AND c.order_type IN (70, 75) AND c.apply_time >= '2023-05-28 00:00:00' AND c.apply_time AND c.supplier_id IN (78, 63, 58, 57, 64, 72, 71, ...

帮我把“SELECT ppo.supplier_id, ppo.supplier_name, count(distinct ppo.id) FROM pm_purchase_order ppo inner join pm_purchase_order_detail ppod on ppo.id = ppod.purchase_order_id -- and ppod.confirm_status = '1' and ppod.del_flag = '0' WHERE ppo.del_flag = '0' GROUP BY ppo.supplier_id, ppo.supplier_name”和“SELECT ppo.supplier_id, ppo.supplier_name, count(distinct ppo.id) FROM pm_purchase_order ppo inner join pm_purchase_order_detail ppod on ppo.id = ppod.purchase_order_id and ppod.confirm_status = '1' and ppod.del_flag = '0' WHERE ppo.del_flag = '0' GROUP BY ppo.supplier_id, ppo.supplier_name”合并成一个SQL语句

inner join pm_purchase_order_detail ppod on ppo.id = ppod.purchase_order_id WHERE ppo.del_flag = '0' AND (ppod.confirm_status = '1' OR ppod.confirm_status <> '1' AND ppod.del_flag = '0') GROUP BY ppo...

SELECT t1.supplier_id,IFNULL(t1.receiptcount,0) as receipt_count,IFNULL(t1.receiptamount,0) as receipt_amount,IFNULL(t2.refundcount,0) as refund_count,IFNULL(t2.refundamount,0) as refund_amount from ( SELECT a.supplier_id, count(DISTINCT a.order_id) AS receiptcount, sum(IFNULL(b.receipt_amount,0))/100 AS receiptamount FROM order_info a left JOIN order_receipt b ON a.order_id = b.order_id WHERE a.order_type IN (70, 75) AND a.is_del = 0 AND a.order_state IN (40, 50, 60) AND a.create_time >= '2023-05-28 00:00:00' AND a.create_time < '2023-05-29 00:00:00' AND a.supplier_id in ( 78,63,58,57,64,72,71,74,83,77,70,69,67,82,65,87,73,59,66,60,86,85,79,80,84,90 ) GROUP BY a.supplier_id order by a.supplier_id ASC ) t1 LEFT JOIN ( select c.supplier_id,count(DISTINCT c.order_id) as refundcount,sum(IFNULL(c.refund_amount,0)) / 100 as refundamount from order_refund c LEFT JOIN order_info d on c.order_id = d.order_id WHERE d.order_type in (70,75) AND d.order_state IN (40, 50, 60) and c.refund_state =13 AND c.is_del = 0 and c.create_time >= '2023-05-28 00:00:00' AND c.create_time < '2023-05-29 00:00:00' AND c.supplier_id in ( 78,63,58,57,64,72,71,74,83,77,70,69,67,82,65,87,73,59,66,60,86,85,79,80,84,90 ) GROUP BY c.supplier_id ) t2 on t1.supplier_id = t2.supplier_id order by t1.supplier_id asc

AND EXISTS (SELECT 1 FROM order_info d WHERE c.order_id = d.order_id AND d.order_type IN (70, 75) AND d.order_state IN (40, 50, 60))) GROUP BY c.supplier_id) t2 ON t1.supplier_id = t2.supplier_id ...

优化以下SQL select pao.id, pao.order_no, pao.apply_time, pao.purchase_user_id, pao.purchase_user_name, pao.apply_user_id, pao.apply_user_name, pao.apply_department_id, pao.apply_department_name, pao.apply_end_time, pao.create_user_id, pao.create_user_name, pao.approve_type, pao.approve_user_id, pao.approve_user_name, pao.approve_time, pao.description, pao.order_type, pao.purchase_type, pao.storage_type, pao.compose_order_no, pao.company_id, pao.delete, pao.create_time, pao.update_time, pao.supplier_id, pao.image_path, pao.contract_id, pao.status, pao.invoice_signer_name, pao.total_amount, pao.total_amount_tax, pao.purchase_status, pao.cancel_reason, pao.print_status, pao.demand_id, pao.arrival_status, pao.supervise_num, pao.supervise_date, pao.merge_apply_id, pao.deadline, pao.remind , s.name as supplierName, paod.amount, cm.return_status as returnStatus, cm.inventory_status as inventoryStatus, cm.stock_remark, cm.merge_flag, cm.signature_file, cm.department_pass, cm.receipt_file, cm.amount_paid, cm.amount_unpaid, cm.contract_name, cm.status as contractStatus, cm.contract_no, cm.contract_amount, paod.product_name, cm.advance_payment, cm.advance_ratio, cm.currency_unit from purchase_apply_order pao left join supplier s on pao.supplier_id = s.id left join ( SELECT GROUP_CONCAT(distinct p.product_name) product_name, sum(IFNULL(amount_tax, 0)) amount, apply_order_no from purchase_apply_order_details pa left join product p on p.pn_code = pa.product_code where p.company_id = 29 GROUP BY apply_order_no ) paod on paod.apply_order_no = pao.order_no left join contract_management cm on pao.contract_id = cm.id where pao.delete = 0 and pao.company_id = 29 and deadline <= '2023-05-25 15:34:00.01' and remind = 0 and arrival_status in( 0 , 1 ) order by pao.create_time desc;

SELECT pao.id, pao.order_no, pao.apply_time, pao.purchase_user_id, pao.purchase_user_name, pao.apply_user_id, pao.apply_user_name, pao.apply_department_id, pao.apply_department_name, pao.apply_end_...

SELECT <include refid="Base_Column_List"/>,a.${timeField} orderTime,b.ticket_no pendingTicketNo, f.rela_id returnGoodsId,f.ticket_no returnGoodsNo,c.is_classes FROM order_info AS a LEFT JOIN order_biz_rela AS b ON a.order_id = b.order_id and b.biz_type=1 and b.is_delete=1 INNER JOIN store_staff AS d ON a.create_user_id =d.user_id and a.store_id=d.store_id INNER JOIN buyer_info AS e ON a.buyer_id=e.buyer_id LEFT JOIN order_biz_rela AS f ON a.order_id = f.order_id and f.biz_type=2 and f.is_delete=1 INNER JOIN classes_biz c ON c.biz_id = a.order_id AND c.biz_type = 1 WHERE a.order_id=#{orderId} 优化

你可以为以下列添加索引：a.order_id、b.order_id、b.biz_type、b.is_delete、d.user_id、d.store_id、e.buyer_id、f.order_id、f.biz_type、f.is_delete、c.biz_id和c.biz_type。另外，你可以考虑使用INNER JOIN...

帮我解释这条sql: select t.order_code root_order_code,t.branch_id,t.platform_id, (select outer_order_code from order_main_extension ome where ome.order_code = t.order_code) outer_order_code, (select group_concat(son.son_order_code) from order_node_root_son son where son.root_order_code=t.order_code) son_order_codes from order_main t where t.order_over=0 and not exists (select 1 from order_node_root_son ts where ts.root_order_code=t.order_code and ts.son_order_state not in ('1','3','4','6')) and exists (select 1 from order_node_root_son ts where ts.root_order_code=t.order_code)

- 选取字段：root_order_code、branch_id、platform_id。 - 子查询1：在表order_main_extension中，根据order_code与主查询的t.order_code进行匹配，选取outer_order_code作为额外的字段。 - 子查询2：在表order_...

select Customers.cust_name,Orders.oder_num from Customers inner join Orders on Customers.cust_id == Orders.cust_id order by Customers.cust_name desc这句SQL有什么语法错误

这句 SQL 语句看起来是...INNER JOIN Orders ON Customers.cust_id = Orders.cust_id ORDER BY Customers.cust_name DESC 这将按照顾客的名称（以降序排列）和订单号选择顾客和订单信息，并将它们结合在一起。

group by dw.wh_code,ui.supplier_id order by dw.wh_code 。SQL语句

以下是按照 dw.wh_code 和 ui.supplier_id ...SELECT dw.wh_code, ui.supplier_id FROM table_name GROUP BY dw.wh_code, ui.supplier_id ORDER BY dw.wh_code ASC; 请将 table_name 替换为你要查询的表名。

SELECT users.username, SUM(orders.order_total) AS total_order_amount, SUM(orders.order_total) / (SELECT SUM(order_total) FROM orders) * 100 AS order_percent FROM users INNER JOIN orders ON users.user_id = orders.user_id GROUP BY users.user_id ORDER BY order_percent DESC; 如何优化

CROSS JOIN (SELECT SUM(order_total) AS sum_order_total FROM orders) AS total_sum_order_total GROUP BY users.user_id ORDER BY order_percent DESC; 同时，可以根据数据量和查询频率，考虑在相关表...

相关推荐

font_select.zip_font_select.zip

[Oracle] dbms_metadata.get_ddl 的使用方法总结

demo.tar.gz_C demo.tar_DEMO_select.c

bs.report_no 是 varchar

将 ORDER BY bs.report_no ASC 这个条件加到代码中应该怎么写

只取bs.report_no 里面的整数 来进行排序也要加cast吗

select o.order_num,o.start_time,o.total,bk.book_name,bk.book_price,od.num,od.total from order o inner join order_detail od on o.order_id=od.order_id where o.user_id=1008611 inner join book bk on od.book_id=bk.book_id;

select Customers.cust_name,Orders.oder_num from Customers inner join Orders on Customers.cust_id == Orders.cust_id order by Customers.cust_name desc这句SQL有什么语法错误

group by dw.wh_code,ui.supplier_id order by dw.wh_code 。SQL语句

SELECT users.username, SUM(orders.order_total) AS total_order_amount, SUM(orders.order_total) / (SELECT SUM(order_total) FROM orders) * 100 AS order_percent FROM users INNER JOIN orders ON users.user_id = orders.user_id GROUP BY users.user_id ORDER BY order_percent DESC; 如何优化

最新推荐

[Oracle] dbms_metadata.get_ddl 的使用方法总结

浪潮服务器NF8460M3安装windows_Server2008.doc

BSC关键绩效财务与客户指标详解

管理建模和仿真的文件

【实战演练】俄罗斯方块：实现经典的俄罗斯方块游戏，学习方块生成和行消除逻辑。

卷积神经网络实现手势识别程序

绘制企业战略地图：从财务到客户价值的六步法

"互动学习：行动中的多样性与论文攻读经历"

【实战演练】井字棋游戏：开发井字棋游戏，重点在于AI对手的实现。

transformer模型对话

只取bs.report_no 里面的整数来进行排序也要加cast吗