Post reply

Counting

  • May 7, 2003 at 4:48 am

    #456374

    Maybe I'm missing the point but...

    Select COUNT(ColName) From Table

    Where

    Event = 'x'

    If you want the number of each event then

    Select COUNT(ColName), EventName From Table

    Where

    Event = 'x'

    Group By EventName

    Cheers,

    Crispin

    Cheers,CrispinI can't die, there are too many people who still have to meet me!It's not a bug, SQL just misunderstood me!

  • May 7, 2003 at 5:35 am

    #456381

    Thanks - that set me of in the right direction.

    I'm all sorted now.

Viewing 2 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply