4 ms·
Well, the "fun" one to consider is IMO not that, but this: SELECT (SELECT sum(a + x) FROM xx LIMIT 1) FROM aa; Making a pretty diagram where all the behav
by indigo945 3y ago
Well, the "fun" one to consider is IMO not that, but this:
SELECT (SELECT sum(a + x) FROM xx LIMIT 1) FROM aa;
Making a pretty diagram where all the behaviours from various DBMSs are listed is left as an exercise to the author. :)
- foldU 3y agoI think this one is obvious actually! There's no choice but to aggregate it at the level of the `xx` `SELECT`, no other level has access to the `x` column.
- MarkusWinand 3y ago> Making a pretty diagram where all the behaviours from various DBMSs are listed is left as an exercise to the author. :) It's there already! It's in the chart as footnote "b": Outer reference must be the only argument (doesn’t support F441) That's the one thing SQL Server doesn't eat. Those that are green in the chart work fine in this case.