distinct与order by

SELECT DISTINCT
    a.DetailId,
    a.OrderId,
    a.ProductId,
    pi2.BarCode,
    pi1.ProductName,
    pi1.productCode,
    pi1.spec,
    a.UnitId,
    ui.UnitName,
    SNUM(a.DetailId) as Quantity,
    a.Discount,
    a.UnitPrice,
    a.TaxRate,
    a.ProductMoney,
    a.TaxMoney,
    a.PayableMoney,
    a.IsGiveAway,
    a.DetailId AS ColGuid,
    a.ParentGuid,
    a.DetailId AS OrderDetailId,
    a.OrderId AS RelevanceOrder,
    a.Memo,
    pi2.SalePrice AS InitUnitPrice,
    a.SEQ,      ---必须包含这个，否则报错
    a.Quantity - SNUM(a.DetailId) AS OutQuantity
FROM
    SaleOrderDetail a
LEFT JOIN ProductInfo pi1 ON a.ProductId = pi1.ProductId
LEFT JOIN ProductPrice pi2 ON a.ProductId = pi2.ProductId
AND pi2.unitid = a.unitid
LEFT JOIN UnitInfo ui ON a.UnitId = ui.UnitId
WHERE
    a.DetailId IN (SELECT COLUMN_VALUE FROM TABLE(SPLITSTR(IDS, ‘,‘)))
ORDER BY
    a.SEQ ASC