>>>>> "Andrew" == Andrew Gierth <andrew(at)tao11(dot)riddles(dot)org(dot)uk> writes:
Andrew> To my knowledge this is the correct result. (Though neither
Andrew> version of the query is legal per the SQL spec; allowing
Andrew> expressions and aliases in GROUP BY are nonstandard
Andrew> extensions.)
And neither Oracle nor MSSQL (at least the versions available on
sqlfiddle) allow either query, so there's nothing I can compare against.
--
Andrew (irc:RhodiumToad)