Logical Query Processing order

Question

Post reply

Logical Query Processing order

Viewing 15 posts - 16 through 30 (of 49 total)

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

rajapriyan_1987 Newbie Points: 8 More actions · Answer 1

Hi,

2 and 4 were identical Answer, It saying wrong answer even when I choose correct answer

Todd Reddinger Ten Centuries Points: 1362 More actions · Answer 2

50/50 shot between the two identicals. I chose poorly.

Thanks,

ToddR

Ed Wagner SSC Guru Points: 287024 More actions · Answer 3

Yeah, I chose poorly as well. There's nothing like a nice trick question that's wrong to mess us up in the morning.

Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions

serg-52 SSCrazy Eights Points: 9913 More actions · Answer 4

select 'Nice' as Topic, ':(' as Wording

from Answers

having count (distinct Option) <> count (Option)

RLilj33 SSCrazy Points: 2153 More actions · Answer 5

Todd Reddinger (11/11/2014)
50/50 shot between the two identicals. I chose poorly.

I chose the correct one by calculated chance. I assumed that if the question was entered by a human, then the more likely place to find a "correct" answer would be among the incorrect ones rather than at the top of the list. If they were randomly placed the odds of guessing which of the correct answers was the "right" one would have been much less. 😉

Is it any wonder that machines that can't program themselves have bugs?

jhli973 SSC Journeyman Points: 98 More actions · Answer 6

ME me. I have noticed that before submitting the answer

Sean Lange SSC Guru Points: 286573 More actions · Answer 7

The topic is certainly relevant but in a QOTD format it is absurd due to the formatting. Add to that the answers are duplicated and you end up with a question that unfortunately didn't work well. Thanks for the effort and the topic is well worth sharing.

_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/

sestell1 SSChampion Points: 10230 More actions · Answer 8

Was very confused when I got this wrong... didn't even notice the duplicate answers. :blink: :rolleyes:

ssimmons 2102 SSCommitted Points: 1634 More actions · Answer 9

I must have read option 1 and 4 - 20 times, looking for something that was different. I chose the 4th one.

stephen.long.1 SSCrazy Points: 2582 More actions · Answer 10

I noticed that 1 and 4 were identical, so I figured they must both be wrong. I also eliminated the ones that included TOP before ORDER BY, because that would produce incorrect results. I then chose option 3 by a process of elimination, which is, of course, wrong. I should have remembered all of the bad questions the past few months and reconsidered 1 and 4.

Oh, well, it's just a point. I should have known the answer, however. Good question (thanks, Shiva), but the options need to be better.

[font="Courier New"]SELECT DISTINCT Choices

FROM QotD

WHERE Title = 'Logical Query Processing order'[/font]

Nakul Vachhrajani SSChampion Points: 10283 More actions · Answer 11

I choose option #1 myself and ended up with a lost point. A refund, please 🙂

Thanks & Regards,
Nakul Vachhrajani.
http://nakulvachhrajani.com

Follow me on
Twitter: @sqltwins

RK Mandava SSCarpal Tunnel Points: 4153 More actions · Answer 12

RK Mandava

SSCarpal Tunnel

Points: 4153

November 11, 2014 at 8:43 am

#1757705

Nice question, Thanks for sharing

trilist SSC Eights! Points: 902 More actions · Answer 13

erwin.oosterhoorn (11/11/2014)
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...

Me too :crying:

jhli973 SSC Journeyman Points: 98 More actions · Answer 14

jhli973

SSC Journeyman

Points: 98

November 11, 2014 at 8:57 am

#1757709

without order by, How can You select the top N?

Nadrek SSC-Insane Points: 20039 More actions · Answer 15

I copy and pasted into a text editor, verified that 1 and 4 were the same, guessed 1 was more likely to get the point, and lost with a correct answer.

Can we have some proofreading of these? Or code that prevents duplicates?