‎01-12-2016 09:09 PM
Select Top 1000000 tblSoftwareUni.softwareName As Software,
Count(tblSoftwareUni.softwareName) As Count
From tblSoftware
Inner Join tblSoftwareUni On tblSoftware.softID = tblSoftwareUni.SoftID
Where (tblSoftwareUni.SoftwarePublisher Like '%Microsoft%') Or
(tblSoftwareUni.SoftwarePublisher Like '%Mozilla%') Or
(tblSoftwareUni.SoftwarePublisher Like '%Google%')
Group By tblSoftwareUni.softwareName
Having (tblSoftwareUni.softwareName Like '%Windows Internet Explorer%') Or
(tblSoftwareUni.softwareName Like '%Firefox%') Or
(tblSoftwareUni.softwareName Like '%Chrome')
Order By Count Desc
Solved! Go to Solution.
‎01-13-2016 07:35 PM
‎01-19-2016 10:05 AM
‎01-13-2016 11:24 PM
‎01-13-2016 07:35 PM
‎01-12-2016 11:06 PM
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now