需求背景
目前清库促销调价查询的数据源存在不全的问题,需要重新调整数据源的查询。
需求内容
SELECT
*
FROM (
SELECT
*,
ROW_NUMBER()OVER(PARTITION BY a.SKU ORDER BY a.AddTime DESC) AS 'rowid'
FROM
dbo.RB_SellerSKU_SubsidyPlan (NOLOCK) AS a
WHERE
a.PlanStatus = 1
AND a.SubsidyStatus = 2
AND (a.WareHouseIDList = '333' OR a.WareHouseIDList = '5312')
) AS a WHERE a.rowid = 1 AND a.SubsidyPlanNum > PlaceNum
