Adding a column header on count function

  • Hi All:

    Is it possible to add a column header to a count?

    i.e. select count(*) from foo as employeeCnt

    Thanks,

    Bill

  • You're close ...

    select count(*) as employeeCnt from foo

    ______________________________________________________________________

    Personal Motto: Why push the envelope when you can just open it?

    If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.

    Jason L. Selburg
  • Thanks Jason, that worked

    Bill

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

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