Hello,
Is there any way to reuse a column label in a select list like this:
SELECT 1 + 1 AS a, a + 1 AS b;
I vaguely remember being able to do something like this in oracle. Any
ideas? Thanks!
~RvR
---(end of broadcast)---
TIP 1: subscribe
There might be a better way then this but this works
SELECT a, a+1 as b from (SELECT 1+1 as a) as ab;
On 16 Oct 2004 11:18:48 -0700, ryan [EMAIL PROTECTED] wrote:
Hello,
Is there any way to reuse a column label in a select list like this:
SELECT 1 + 1 AS a, a + 1 AS b;
I vaguely
* ryan [EMAIL PROTECTED] [2004-10-16 11:18:48 -0700]:
Is there any way to reuse a column label in a select list like this:
SELECT 1 + 1 AS a, a + 1 AS b;
I vaguely remember being able to do something like this in oracle. Any
ideas? Thanks!
You could nest them...
xinu= select (1 + 1)