随笔分类 -  SQL-HQL

往with as中写入数据的方法
摘要：方法1：直接写入，使用union all,简单直观，但程序运行效率低，几百条就很慢了 with dw_wms_outbound_info_v100 as( select '10700001' as order_no, '0011' as shop_no, '5501' as product_code 阅读全文
posted @ 2020-10-19 17:40 emilynotes 阅读(431) 评论(0) 推荐(0)