goodsid对应多个barcode,将barcode用“,”隔开做成一行数据
select wm_concat(barcode),GOODSID from barcode group by GOODSID;
goodsid对应多个barcode,取出数据goodsid对应第一条或者最后一条barcode记录
select goodsid,barcode from (SELECT goodsid,barcode, Row_Number() OVER (partition by goodsid ORDER BY barcode ASC ) SS FROM barcode ) WHERE SS<2