AVG function

  • Comments posted to this topic are about the item AVG function

  • Simple QotD today.

    -----------------
    Gobikannan

  • Thank you Krishna

    M&M

  • Nicee and easy if you read the question properly...

  • Easy question if you don't talk yourself into thinking it's a trick question.

    http://brittcluff.blogspot.com/

  • I made the same mistake I make all the time and forget about the datatypes.

    Good Question to make you think.

  • Good question. Thanks.

  • Makes it even more interesting if you add following:

    insert into @test-2 values ( NULL )

    Answer is still 6.

    Mike Byrd

  • Mike Byrd (6/21/2011)


    Makes it even more interesting if you add following:

    insert into @test-2 values ( NULL )

    Answer is still 6.

    Because aggregate functions ignore NULLs, right?

    Good question today, thanks. I had it nailed on theory and then almost got it wrong by screwing up the math. 24 divided by 4 is NOT 8, duh. Tuesday morning brain, I guess.

    ron

    -----
    a haiku...

    NULL is not zero
    NULL is not an empty string
    NULL is the unknown

  • Britt Cluff (6/21/2011)


    Easy question if you don't talk yourself into thinking it's a trick question.

    I have noticed that thier have not been any question that could be confused as a "Trick Question" in a LONG time. 😛

    Thank you Steve! 😀

  • Nice easy clear to understand question. Thank you.

  • Nice question. Simple and straight forward.

  • Yay - thanks for the ?

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • Thanks for the question. Reminds us to remember those datatypes.

  • Thanks. Good to see questions about things that come up all the time 🙂

    _____________________________________________________________________
    MCSA SQL Server 2012

Viewing 15 posts - 1 through 15 (of 25 total)

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