SELECT ARP.DisplayName0, ARP.ProdID0, ARP.Publisher0, ARP.Version0, Count(ARP.ProdID0) AS 'Count'FROM dbo.v_Add_Remove_Programs ARPGROUP BY ARP.DisplayName0, ARP.ProdID0, ARP.Publisher0, ARP.Version0ORDER BY ARP.DisplayName0