Hi all,

First post here, I have the following query:

1> select ExtractorId from dmLC_FAILQUEUE
2> go
ExtractorId
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
EXTR_GCD_PROD
EXTR_GCD_PROD
EXTR_GCD_PROD
EXTR_GCD_PROD
EXTR_LDN_PROD
EXTR_LDN_PROD
EXTR_LDN_PROD
EXTR_LDN_PROD
EXTR_NY_PROD
EXTR_NY_PROD
EXTR_NY_PROD
EXTR_SNG_PROD


I've been trying to develop a subquery that allows me to count the number of times every different ExtractorId appears in the query (for example EXTR_GCD_PROD 4, EXTR_LDN_PROD 4, EXTR_NY_PROD 3, etc) but no luck so far. Any ideas how this could be done?

use COUNT(*) with GROUP BY

Thanks very much!