Tag Info

New answers tagged


OK, I'll take the provided example, and modify it a bit: select (<insanely complex expression>) as pop, case when pop is null then 'isnull' end from rap4 ; The above will of course produce an error because an alias defined in the SELECT list, cannot be used in another expression in the same SELECT list or the (same level) ...

Top 50 recent answers are included