Logical Query Processing order

Question

Post reply

Logical Query Processing order

Shiva N

Hall of Fame

Points: 3125
More actions
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 11, 2014 at 4:05 am

This was removed by the editor as SPAM

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

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

kherald69 SSC Eights! Points: 971 More actions · Answer 1

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

Mr. Kapsicum SSCertifiable Points: 6128 More actions · Answer 2

Mr. Kapsicum

SSCertifiable

Points: 6128

November 10, 2014 at 10:40 pm

#1757604

Option 1 and 4 are identical.

Umer Akram SSC-Insane Points: 22209 More actions · Answer 3

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

Very nice question, Thanks for sharing

Neil Burton SSC-Insane Points: 23062 More actions · Answer 4

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

edwardwill SSCertifiable Points: 5926 More actions · Answer 5

edwardwill

SSCertifiable

Points: 5926

November 11, 2014 at 2:12 am

#1757621

I chose option 1 also.

Sean of the Lynchmob Ten Centuries Points: 1038 More actions · Answer 6

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

gysev1207 SSC Veteran Points: 223 More actions · Answer 7

gysev1207

SSC Veteran

Points: 223

November 11, 2014 at 3:21 am

#1757633

why #1 is incorrect&

rodjkidd SSCoach Points: 15919 More actions · Answer 8

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

milanmcas Say Hey Kid Points: 671 More actions · Answer 9

Hi,

all options are wrong where

2nd and 4th options are same.

edwardwill SSCertifiable Points: 5926 More actions · Answer 10

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!

Erwin Oosterhoorn SSCrazy Points: 2320 More actions · Answer 11

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

SqlMel SSCrazy Points: 2901 More actions · Answer 12

SqlMel

SSCrazy

Points: 2901

November 11, 2014 at 4:47 am

#1757649

Very good question. Thanks.

---------------
Mel.

venoym SSCarpal Tunnel Points: 4161 More actions · Answer 13

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

Logical Query Processing order

Cookies on SQLServerCentral