i want to count the number of occurrences of different sensor rows in SQL, but i seem to be doing it wrong and seemingly i am not visualizing it correctly.
if i was doing this in pseudocode in a c style language i would do it like this:
FOR i in range(taglist[i]): print(taglist[i], count(taglist[i]) )
i have been trying this:
Select Count(a) FROM ( SELECT Distinct [TagName] FROM [A2ALMDB].[dbo].[AlarmMaster] where (TagName like '%Sensor%' or GroupName like'%Sensors%') ) a
it returns ’66’, but i want it to return the count of each of the distinct tagnames that are returned in Select A.
Can anyone help me with how i should be trying to get all the counts of my different sensor occurrences to total instead of a count of all the distinct tagnames?
thanks for the help!