Post reply

Assigning categories to values 2

  • May 17, 2013 at 9:23 am

    #1616229

    Nice question, good explanation. No SQL weirdness like that in yesterday's question, so much easier.

    Hugo Kornelis (5/15/2013)

    Dave62 (5/15/2013)

    A minor typo in the explanation.

    "... As soon as one evaluates to True, the corresponding ELSE is returned. ..."

    ELSE should be THEN in that sentence.

    and

    hany.helmy (5/15/2013)

    In the Explanation: "A CASE expression will always evaluate the WHEN clauses from top to bottom. As soon as one evaluates to True, the corresponding [ELSE] is returned."

    I think it should be the corresponding [THEN] not else, correct me if I am wrong.

    You are both absolutely right. Sorry for that mistake. Unfortunately, I am unable to change the explanation. 🙁

    Steve will correct it for you if you ask him (private message works quite well for that) - it is better if simple errors in questions are fixed so that people who come across them later are not confused or misled.

    Tom

  • May 17, 2013 at 11:56 pm

    #1616377

    Straightforward Question.

    Thanks

    David

  • May 23, 2013 at 3:24 am

    #1617769

    Easier question with lot more information.

    --
    Dineshbabu
    Desire to learn new things..

  • May 28, 2013 at 2:59 am

    #1618885

    Easy question for me. Dank je, Hugo.

    Got bit by the evaluation of aggregates a while back and forgot about it so it's good to be reminded. Nogmaals hartelijk dank, Hugo.

Viewing 4 posts - 31 through 33 (of 33 total)

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