摘要：UPDATE B SET B.BZSL = A.SL FROM (select A.itemno , SUM(bar_singleSL) SL from ERP_CPGL_BZ_detail_barcode A INNER JOIN ERP_CPGL_bz_main B on B.djno = A. 阅读全文

摘要：思路一：将空值转换为最小值 select isnull(xsdd_dzid_pre,-1),* from xsdd_dzbh order by 1 --oracle使用nvl 思路二：oracle的nulls first 和 nulls last select xsdd_dzid_pre,* fro 阅读全文

摘要：##执行顺序 SELECT --(8) DISTINCT<select_list> --(9) FROM <left_table> --(1) <join_type> JOIN <right_table> --(3) ON <join_condition> --(2) WHERE <where_co 阅读全文

摘要：要求 查询出11月份的数据 错误语句 select DISTINCT C.kingdee_sku_name ,--物料名称 SUM( B.tzzl) OVER(PARTITION BY SUBSTRING(B.sku_bj,7,2)) , 重量 SUM(B.sl) OVER(PARTITION BY 阅读全文