Count of sound cards

 

SELECT v_GS_SOUND_DEVICE.ProductName0 AS ‘Name’, Count(v_GS_SOUND_DEVICE.ProductName0) AS ‘Count’

FROM v_GS_SOUND_DEVICE v_GS_SOUND_DEVICE

GROUP BY v_GS_SOUND_DEVICE.ProductName0

ORDER BY v_GS_SOUND_DEVICE.ProductName0

Leave a Reply

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