Please don’t snigger, but I just learned this useful little SQL nugget:
SELECT (SELECT 1 FROM dual) AS one, (SELECT 2 FROM dual) AS two, (SELECT 3 FROM dual) AS three FROM dual;
Voila!
OK! OK! I admit my knowledge of SQL is bad!
I never did like Assembly Languages (although I admit to a soft spot for the Motorola 68000 series).
I can’t work out why the data-oriented community is so resistant to the clear need to evolve away from this rubbish.
Heaven knows, for the good old 80% case, we can do much better.
