我只想查詢沒有任何先前交易的資料
This is the Query Result
sku barcode details load_dt
546 a674 testabc2 2021-10-21
546 a674 testabc2 2021-10-17
111 a111 test1111 2021-10-21
111 a111 test1111 2021-10-20
333 a333 test3333 2021-10-21
444 a444 test4444 2021-10-21
Expected Result
sku barcode details load_dt
333 a333 test3333 2021-10-21
444 a444 test4444 2021-10-21
uj5u.com熱心網友回復：
您可以使用GROUP BY和HAVING過濾只有 1 行的資料
SELECT * FROM trans WHERE sku IN (
SELECT sku
FROM trans
GROUP BY sku
HAVING COUNT(*) = 1)
在這里，我創建了dbfiddle
轉載請註明出處，本文鏈接：https://www.uj5u.com/qiye/328788.html
標籤：sql sql-server 查询语句