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