This should be easy right? just need a total of the Tier_cnt. Should be 80 but I want the server to tell me.
Thanks
Select tier, count(tier) as tier_cnt
from leads
group by tier
tier tier_cnt
---------------- ----
NULL 0
5
Other 35
Tier 1 25
Tier 2 11
Tier 3 4
Tier_tot
---
????Add the COMPUTE function to your SELECT
Select tier, count(tier) as tier_cnt
from leads
group by tier
compute sum(count(tier))|||Muito Gracias
Exactly what I needed.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment