Post reply

Logical Query Processing order

  • November 10, 2014 at 8:44 pm

    #292374

    Comments posted to this topic are about the item Logical Query Processing order

    Thanks,
    Shiva N
    Database Consultant

  • November 10, 2014 at 9:43 pm

    #1757602

    :ermm: Is it just me or are options 1 and 4 identical?

    Option #1: FROM,ON,JOIN,WHERE,GROUP BY,CUBE | ROLLUP,HAVING,SELECT,DISTINCT,ORDER BY,TOP

    Option #4: FROM,ON,JOIN,WHERE,GROUP BY,CUBE | ROLLUP,HAVING,SELECT,DISTINCT,ORDER BY,TOP

    I chose option #1 and it looks like I'm not alone.

  • November 10, 2014 at 10:40 pm

    #1757604

    Option 1 and 4 are identical.

    🙂

  • November 11, 2014 at 12:06 am

    #1757611

    No matter whats happens later in today about identical answer or not.

    Very nice question, Thanks for sharing

  • November 11, 2014 at 1:33 am

    #1757616

    I suspect not as many people will get this right as they should because one of the two identical options returns a wrong answer.

    On two occasions I have been asked, "Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?" ... I am not able rightly to apprehend the kind of confusion of ideas that could provoke such a question.
    —Charles Babbage, Passages from the Life of a Philosopher

    How to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537

  • November 11, 2014 at 2:12 am

    #1757621

    I chose option 1 also.

  • November 11, 2014 at 2:18 am

    #1757622

    It IS a very good question, however as has been already mentioned, options 1 and 4 are identical but choosing option 1 is marked incorrect. Still, I guess it made me question my understanding of logical processing and made me swot up to make sure I really did understand the logical processing order; as it helped reinforce my knowledge, I won't complain about being marked wrong! 😉

    Sean

  • November 11, 2014 at 3:21 am

    #1757633

    why #1 is incorrect&

  • November 11, 2014 at 3:32 am

    #1757634

    Nice, 50 / 50 on which of 1 or 4 is the "correct" answer. Would appear I picked the wrong "correct" one 🙂

    I wonder what the wording of 1 should be, to be a wrong answer?

    Rodders...

  • November 11, 2014 at 3:47 am

    #1757635

    Hi,

    all options are wrong where

    2nd and 4th options are same.

  • November 11, 2014 at 3:49 am

    #1757636

    I don't often answer these questions, but of the few times I have, twice the answers have been wrong. Pretty poor proof-reading; wouldn't trust them with my database! 😀

  • November 11, 2014 at 3:50 am

    #1757638

    I have a reference here that states that the last three are distinct, top then order by. This is from the book inside Microsoft SQL server 2008 - T-SQL Querying.

    So I chose the wrong answer...

  • November 11, 2014 at 4:05 am

    This was removed by the editor as SPAM

  • November 11, 2014 at 4:47 am

    #1757649

    Very good question. Thanks.

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

  • November 11, 2014 at 4:56 am

    #1757652

    Either they fixed it or something because now options 1 and 4 are different.

    Option #1: FROM,ON,JOIN,WHERE,GROUP BY,HAVING,CUBE | ROLLUP,SELECT,DISTINCT,ORDER BY,TOP

    Option #4: FROM,ON,JOIN,WHERE,GROUP BY,CUBE | ROLLUP,HAVING,SELECT,DISTINCT,ORDER BY,TOP

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

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