WinZip count with version
Originally published on TechColumnist.
SELECT ProductName0 AS Product, VersionMajor0 AS Version, COUNT(*) AS Count FROM dbo.v_GS_INSTALLED_SOFTWARE GROUP BY ProductName0, VersionMajor0 HAVING (ProductName0 = 'winzip')
technology executive leadership
Originally published on TechColumnist.
SELECT ProductName0 AS Product, VersionMajor0 AS Version, COUNT(*) AS Count FROM dbo.v_GS_INSTALLED_SOFTWARE GROUP BY ProductName0, VersionMajor0 HAVING (ProductName0 = 'winzip')