Comments on: Pop quiz: what would be the results of the following queries? https://shlomi-noach.github.io/blog/mysql/pop-quiz-what-would-be-the-results-of-the-following-queries Blog by Shlomi Noach Thu, 12 May 2011 14:24:46 +0000 hourly 1 https://wordpress.org/?v=5.3.3 By: shlomi https://shlomi-noach.github.io/blog/mysql/pop-quiz-what-would-be-the-results-of-the-following-queries/comment-page-1#comment-39602 Thu, 12 May 2011 14:24:46 +0000 https://shlomi-noach.github.io/blog/?p=3445#comment-39602 @Mark: Douze Point! (You have to be a Eurovision watcher to understand this)

]]> By: shlomi https://shlomi-noach.github.io/blog/mysql/pop-quiz-what-would-be-the-results-of-the-following-queries/comment-page-1#comment-39599 Thu, 12 May 2011 13:08:20 +0000 https://shlomi-noach.github.io/blog/?p=3445#comment-39599 @kabel
No tricks of this sort. This is an honest SQL question 🙂

]]> By: kabel https://shlomi-noach.github.io/blog/mysql/pop-quiz-what-would-be-the-results-of-the-following-queries/comment-page-1#comment-39597 Thu, 12 May 2011 12:39:32 +0000 https://shlomi-noach.github.io/blog/?p=3445#comment-39597 Is this some trickeration involving the ordering of ENUM values? Or am I barking up the wrong tree?

]]> By: Mark Leith https://shlomi-noach.github.io/blog/mysql/pop-quiz-what-would-be-the-results-of-the-following-queries/comment-page-1#comment-39589 Thu, 12 May 2011 11:10:24 +0000 https://shlomi-noach.github.io/blog/?p=3445#comment-39589 I’d expect the first to return the results order by continent first, then essentially some undefined order afterwards.

The second I would expect the country that comes first alphabetically to return with each continent (Namibia with Africa, Nepal with Asia etc.).

The third, I’d expect one row with Namibia and some undefined continent – because you are grouping by the literal string ‘c’.

]]>