大家帮忙哈，新手，谢谢~~~~~~~~~~`

我需要从   CuttingPiecesRecords   中查询，语句就是下面的：

SELECT DISTINCT
SUBSTRING(CuttingColorNO, 0, CHARINDEX('#', CuttingColorNO)) AS 订单号,
SUBSTRING(CuttingColorNO,10,14) as 花色号,
CuttingBatchNO as 裁剪批号                                                                        
FROM
CuttingPiecesRecords                                                                                    
WHERE CuttingPiecesRecords.Quantity<>0 AND CuttingPiecesRecords.EventType='4'

但是这样的话    查询出来的三个字段中，都有重复的，，我想是以  订单号  为主，然后现实其他两个字段的信息，不知道用什么方法可以把重复的数据过滤掉啊？？？？？？？？？？？