add batch remove batch split batch comment selection show hidden batches hide batch highlight batch
db<>fiddle
donate feedback about
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
商品條碼 會員價 牌價
123 1000 1010
456 2000 2010
商品條碼 商品價格 會員價格 牌價 修改日期 修改序號
123 1200 950 1010 20200101 1
123 1100 900 1020 20200101 2
123 3200 2950 3010 20200201 1
123 3100 2900 3020 20200201 2
456 5200 4950 5010 20200301 1
456 5100 4900 5020 20200301 2
456 7100 6950 7010 20200401 1
456 7200 6900 7020 20200401 2
2 rows affected
商品條碼 會員價 牌價
123 2950 3010
456 6900 7020