SQLserver查询问题，DISTINCT去重之后，还是有重复值

Question

由于销售员录入信息的操作不当，导致不同价格的产品信息公用一条编号。
我distinct之后还是会显示重复的编号，因为价格不同，但是我只要一个编号，我该怎么写才能让他们不重复！！

这是我写的SQL，里面有重复的数据，我抽取一条编号给你们看：

Answer 1

SELECT DISTINCT
A.FLOT,
A.FLOT_TEXT,
A.FBILLNO,
A.FNUMBER,
A.FOLDNUMBER,
(SUM(A.FREALQTY)/COUNT(A.FREALQTY))[FREALQTY],
(sum(A.FPRICE*A.FREALQTY)/SUM(A.FREALQTY)) [FPRICE],
CONVERT(varchar(7), B.FDATE, 120 )[FDATE]
FROM (SELECT DISTINCT
TSI.FLOT,
TSI.FLOT_TEXT,
TS.FBILLNO,
TBM.FNUMBER,
TBM.FOLDNUMBER,
TSI.FMATERIALID,
TSI.FREALQTY,
TF.FPRICE
FROM T_STK_INSTOCKENTRY TSI
LEFT JOIN T_STK_INSTOCK TS ON TSI.FID=TS.FID
LEFT JOIN T_BD_MATERIAL TBM ON TSI.FMATERIALID=TBM.FMATERIALID
LEFT JOIN T_STK_INSTOCKENTRY_F TF ON TSI.FENTRYID=TF.FENTRYID
WHERE EXISTS (SELECT TAO.FLOT FROM T_AR_RECEIVABLEENTRY_O TAO WHERE TAO.FLOT=TSI.FLOT)
AND TSI.FLOT!=''
AND TS.FCANCELSTATUS='A'
AND TS.FDOCUMENTSTATUS='C'
) A LEFT JOIN (SELECT TAO.FLOT,TR.FDATE FROM T_AR_RECEIVABLEENTRY_O TAO JOIN T_AR_RECEIVABLE TR ON TAO.FID=TR.FID WHERE TAO.FLOT!='') B
ON A.FLOT=B.FLOT
GROUP BY A.FLOT,
A.FLOT_TEXT,
A.FBILLNO,
A.FNUMBER,
A.FOLDNUMBER,
B.FDATE