Home Forums Article Discussions Article Discussions by Author Discuss content posted by Charles Kincaid Using a column name in a COUNT function RE: Using a column name in a COUNT function

  • January 30, 2015 at 3:52 pm

    #1774505

    Sean Lange (1/30/2015)

    Or even this:

    select count(1/0) from myTable

    Ooo, I like that! That could break somebody's brain when they stumbled up it.

    This is cool to the appropriate nerds too:

    select count(distinct 1) from myTable

    select count(distinct NEWID()) from myTable

    Distinct with a literal will always return 1, but with newid will give you the table's row count.

    Don Simpson


    I'm not sure about Heisenberg.