• How about good ol' grouping to remove duplicates and supply any of the minimum, maximum, sum, count, average, etc. etc?

    select ItemNumber, min(UnitCost) as MinCost from MissingItems

    group by ItemNumber;

    ItemNumberMinCost

    77710.10

    88813.13

    99916.16