Post reply

Aggregates in T-SQL

  • December 22, 2012 at 2:11 pm

    #1571155

    Nice easy one.

    The third query is clearly going to give an error, and that eliminates all but two of the options, so it boils down to whether select count(x) from something where x is null can ever deliver anything other than 0; it can't, because count(x) ignores nulls and that leaves only the correct option.

    Tom

  • December 26, 2012 at 8:40 am

    #1571581

    Good question. Honestly I hadn't cared much about SUMs including NULLs. Great to know this.

    Saludos,

    "El" Jerry.

    "A watt of Ottawa" - Gerardo Galvan

    To better understand your help request, please follow these best practices.[/url]

  • January 3, 2013 at 5:54 am

    #1573272

    Good question. Catching up on QotD, been on vacation.

  • January 15, 2013 at 1:33 pm

    #1577517

    Good One.

  • January 22, 2013 at 7:23 am

    #1579628

    Thanks for the query...:-)

    Manik
    You cannot get to the top by sitting on your bottom.

Viewing 5 posts - 16 through 19 (of 19 total)

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