Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2002
    Posts
    2

    Unanswered: Newbie-Grand Total

    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
    ---------
    ????????

  2. #2
    Join Date
    Dec 2001
    Location
    Toronto, Canada
    Posts
    335
    Add the COMPUTE function to your SELECT

    Code:
    Select tier, count(tier) as tier_cnt 
    from leads 
    group by tier 
    compute sum(count(tier))

  3. #3
    Join Date
    Feb 2002
    Posts
    2
    Muito Gracias

    Exactly what I needed.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •