Count of Modem Types

My test database has External Modem, Internal Modem, and Null Modem

 

SELECT  MOD.DeviceType0,
Count(MOD.DeviceType0) AS ‘Count of DeviceType0’
FROM  v_GS_MODEM_DEVICE MOD
GROUP BY MOD.DeviceType0

 
 

Leave a Reply

Your email address will not be published. Required fields are marked *