Logical Query Processing order

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

    Thanks,
    Shiva N
    Database Consultant

  • :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.

  • Option 1 and 4 are identical.

    πŸ™‚

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

    Very nice question, Thanks for sharing

  • 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

  • I chose option 1 also.

  • 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

  • why #1 is incorrect&

  • 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...

  • Hi,

    all options are wrong where

    2nd and 4th options are same.

  • 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! πŸ˜€

  • 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...

  • This was removed by the editor as SPAM

  • Very good question. Thanks.

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

  • 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