Home Forums Article Discussions Article Discussions by Author Discuss content posted by Andy Riley Using Ranking Functions to Deduplicate Data RE: Using Ranking Functions to Deduplicate Data
phil.wood 94423
Old Hand
Points: 335
More actions
July 27, 2010 at 1:55 am
#1198572
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