TSQL "where - 101"

  • Comments posted to this topic are about the item TSQL "where - 101"

    -------------------------------Posting Data Etiquette - Jeff Moden [/url]Smart way to ask a question
    There are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. ― Carl Sagan
    I would never join a club that would allow me as a member - Groucho Marx

  • Very Easy 🙂

  • Nice 'n' eazy.

    Thanks & Best Regards,
    Hany Helmy
    SQL Server Database Consultant

  • None of the answers are correct when you take into account the names are with a capital and the answers are lower case, the question was to give all names from the table, answer 3 and 4 do this. Never was the question to give all names duplicates included. Question could be better worded.

  • Both choice 3 and 4 is correct.Because author does not say duplicate names are ok.:crazy:

  • This was removed by the editor as SPAM

  • Stewart "Arturius" Campbell (11/12/2014)


    Good question, thanks Stuart

    erwin.oosterhoorn (11/12/2014)


    None of the answers are correct when you take into account the names are with a capital and the answers are lower case, the question was to give all names from the table, answer 3 and 4 do this. Never was the question to give all names duplicates included. Question could be better worded.

    That would depend on the case sensitivity / collation of the database you are working in.

    It was sparked by new dev here, who couldn't see the difference between any of the four possible answers :w00t:

    As the question and answer showed mixed cases, case insensitivity is implied, again something missed by our now ex dev.

    -------------------------------Posting Data Etiquette - Jeff Moden [/url]Smart way to ask a question
    There are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. ― Carl Sagan
    I would never join a club that would allow me as a member - Groucho Marx

  • The question said "every employee", that should be clear enough, one record per employee. If you DISTINCT, you get list of peoples names, not people.

    "There's Brian over there, and that's another Brian here. But they are both the same, so make them one cup of tea between them"

  • Nice basic question

  • Mark Grout (11/12/2014)


    The question said "every employee", that should be clear enough, one record per employee. If you DISTINCT, you get list of peoples names, not people.

    "There's Brian over there, and that's another Brian here. But they are both the same, so make them one cup of tea between them"

    I agree. There are no need to fuzz over the question being "worded badly" as erwin.oosterhoorn and vivekjamshedpur says..

  • Stuart Davies (11/12/2014)


    It was sparked by new dev here, who couldn't see the difference between any of the four possible answers :w00t:

    As the question and answer showed mixed cases, case insensitivity is implied, again something missed by our now ex dev.

    I cringe when I read this. A new dev who have no clue about boolean expressions. No wonder you name him/her "our now ex dev", because that's a steep hill, this one is trying to climb!

  • Thanks for the question.

    ---------------
    Mel. 😎

  • Mark Grout (11/12/2014)


    The question said "every employee", that should be clear enough, one record per employee. If you DISTINCT, you get list of peoples names, not people.

    "There's Brian over there, and that's another Brian here. But they are both the same, so make them one cup of tea between them"

    +1

    ---------------
    Mel. 😎

  • Stuart Davies (11/12/2014)


    It was sparked by new dev here, who couldn't see the difference between any of the four possible answers :w00t:

    As the question and answer showed mixed cases, case insensitivity is implied, again something missed by our now ex dev.

    And here I was reading them thinking to myself that it must have been strange trying to come up with the wrong answers. Granted, we see a lot of stuff in our own systems and here, but for something so simple, it must have been weird. A nice, simple, unambiguous question, Stuart. Thanks.

  • vivekjamshedpur (11/12/2014)


    Both choice 3 and 4 is correct.Because author does not say duplicate names are ok.:crazy:

    No, they aren't. He even bolded the word "all" in the question. Even without bolding it, it would have still meant the same thing.

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

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