September 28, 2017 at 8:43 pm
Comments posted to this topic are about the item Logical Query Processing Filters
September 28, 2017 at 10:02 pm
Having is last not group by. Answer is wrong.
September 28, 2017 at 11:36 pm
HAVING is processed after GROUP BY. I suspect the question author thought of ORDER BY instead of GROUP BY?
September 29, 2017 at 12:04 am
Bzzzt!
September 29, 2017 at 12:08 am
Is it a typo?
September 29, 2017 at 12:43 am
Confused by answer has everyone missed something?
...
September 29, 2017 at 1:05 am
Answer is incorrect (explanation confirms it), points will probably be re-awarded soon.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
September 29, 2017 at 1:05 am
Terje Hermanseter - Thursday, September 28, 2017 11:36 PMHAVING is processed after GROUP BY. I suspect the question author thought of ORDER BY instead of GROUP BY?
ORDER BY doesn't filter rows.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
September 29, 2017 at 1:19 am
Another borked QotD
September 29, 2017 at 1:44 am
Rune Bivrin - Friday, September 29, 2017 12:04 AMBzzzt!
Tht's true! I agree.
September 29, 2017 at 2:34 am
Scientific progress goes BOINK!!!
September 29, 2017 at 2:40 am
All questions and answers must be checked, checked and checked again. Just like successful code!
You never know: reading my book: "All about your computer" might just tell you something you never knew!
lulu.com/kaspencer
September 29, 2017 at 2:47 am
Or at least reread once...
Happens too many times in my opinion.
September 29, 2017 at 3:17 am
I'm also part of the 91% who got this wrong.
Well done to the rest!
September 29, 2017 at 4:23 am
I'm glad I'm not in the minority on this. Out of the choices, I selected HAVING as the answer as well.
Viewing 15 posts - 1 through 15 (of 29 total)
You must be logged in to reply to this topic. Login to reply