Distinct + Count

[Lost User]

I want to find distinct country and count of each country from a country table. How should I do? Result: Country | Count Japan | 10 UK | 8 Canada | 12

***** Programme comme si dept soutien technique. est plein de tueurs en série et ils savent adresse de votre domicile. *****

[Ravi Sant]

select country, count(country) from countrytable group by country

// ♫ 99 little bugs in the code, // 99 bugs in the code // We fix a bug, compile it again // 101 little bugs in the code ♫

[Lost User]

Thank You, I missed group by.

***** Programme comme si dept soutien technique. est plein de tueurs en série et ils savent adresse de votre domicile. *****

[Lost User]

Is is not working for null country and does not give correct count Hepl ?

***** Programme comme si dept soutien technique. est plein de tueurs en série et ils savent adresse de votre domicile. *****

[Blue_Boy]

Use isnull for your count field. e.g

select country, count(isnull(country,0)) from countrytable
group by country

---

I Love T-SQL "Don't torture yourself,let the life to do it for you." If my post helps you kindly save my time by voting my post. www.cacttus.com

[SilimSayo]

If country is null, it need not be shown. I would say

select country, count(country) from countrytable
where country is not null
group by country