sql server 中 聯合查詢怎么去重啊，只根據一個欄位去重 只想根據sparepart.id 去重
select
sparepart.id,sparepart.snNumber,sparepart.spNumber,sparepart.warehousingId,sparepart.outWarehousingId,sparepart.equipmentId,sparepart.parentId,sparepart.inTime,sparepart.outTime,sparepart.remark,
sparepart.supplierId,sparepart.isMachine,sparepart.status,sparepart.abnormal,sparepart.goodOrBad,sparepart.warrantyStartDate,sparepart.warrantyEndDate,
sparepart.wareHouseId,sparepart.wwNumber,sparepart.ctNumber,sparepart.createUserId,sparepart.createTime,sparepart.inUserId,sparepart.outUserId,
sparepart.waybillNo,sparepart.useStatus,sparepart.state,sparepart.shelfLocation,
equipment.id equipment_id,equipment.name equipment_name,
supplier.id supplier_id,supplier.name supplier_name,
warehouse.id warehouse_id,warehouse.name warehouse_name,
dbuser.id user_id,dbuser.name user_name,
outwarehousing.id outwarehousing_id,outwarehousing.wareHouseId outwarehousing_wareHouseId,outwarehousing.inWareHouseId outwarehousing_InWareHouseId
from sparepart
left join equipment on sparepart.equipmentId = equipment.id
left join supplier on sparepart.supplierId = supplier.id
left join warehouse on sparepart.wareHouseId = warehouse.id
left join outwarehousesparepart on outwarehousesparepart.sparePartId = sparepart.id
left join dbo.[user] dbuser on dbuser.id = sparepart.createUserId
left join outwarehousing on outwarehousing.id = sparepart.outwarehousingId
where sparepart.status = 0
uj5u.com熱心網友回復：
去重至少要兩個要素，一是分組欄位， 你這里有了 sparepart.id
二是重復記錄， 按什么規則去取舍？ 這個你沒有定下來
uj5u.com熱心網友回復：
------問題描述不清楚，無法給出具體實現代碼。
SELECT Distinct sparepart.id FROM sparepart
uj5u.com熱心網友回復：
對的 去重必須有一個或者多個重復欄位 這些重復欄位也是你的分組條件另外還要有一個資料篩選欄位，也就是決定留下哪一潭訓者洗掉哪一些 否則去重沒有意義
uj5u.com熱心網友回復：
CREATE TABLE #T (ID INT IDENTITY,RQ DATE ,SL INT)
INSERT INTO #T(RQ,SL)
VALUES('2019-01-01',1),
('2019-01-03',3),
('2019-01-04',-1),
('2019-01-05',-3),
('2019-01-07',1);
WITH CTE AS(
SELECT ID,RQ,SL,HJ=SL FROM #T WHERE ID=1
UNION ALL
SELECT T.ID,T.RQ,T.SL,HJ=T.SL+CTE.HJ FROM #T T INNER JOIN CTE ON T.ID=CTE.ID+1)
SELECT * FROM CTE
DROP TABLE #T
uj5u.com熱心網友回復：
學習中，認真看看！轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/146859.html
標籤：疑難問題
上一篇：求1到20的積