SQL query instead of loop

Question

I have data corpus like:

DeviceID     Country
id_1         country_1
id_2         country_1
id_3         country_1
id_4         country_2
id_5         country_2
id_6         country_2

and I want result like:

DistCountries    DeviceCount
country_1        3
country_2        3

I have used following query to extract distinct country list:

SELECT DISTINCT(Country) as DistCountries FROM devices;

But, I don't know what can be done to get the required results. Can this be done instead of loops? Any help would be appreciated.

marc_s · Accepted Answer · 2016-03-21 16:07:04Z

4

Try:

SELECT country, count(*) 
FROM devices
GROUP BY country;

edited Mar 21, 2016 at 16:07

marc_s

760k186 gold badges1.4k silver badges1.5k bronze badges

answered Mar 21, 2016 at 16:06

David Aman

3911 silver badge8 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

SQL query instead of loop

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related