云中雪的专栏

WITH 库存单 As (   Select 库存单流水号,检验单据编号,物料编号,批次,筛选编号     , ROW_NUMBER() OVER(Partition By 库存单流水号,检验单据编号,物料编号,批次,筛选编号 Order By 库存单流水号) AS RN     , RANK() OVER(Partition By 库存单流水号,检验单据编号,物料编号,批次,筛选编号 O