22,209
社区成员
发帖
与我相关
我的任务
分享
;WITH cte AS (
SELECT item_no ,
item_subno ,
item_name ,
barcode ,
ROW_NUMBER() OVER ( PARTITION BY barcode ORDER BY item_no ) AS num
FROM bw9kbzpro_01.dbo.bi_t_item_info
)
SELECT item_no ,
item_subno ,
item_name ,
barcode
FROM cte
WHERE barcode='6915120888886' AND num = 1
1000000000168 1000000120014 水饺粉 6915120888886
1000000000221 1000000010003 民天水饺粉 6915120888886