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 remember being able to do something like this in oracle. Any > ideas? Thanks! > > ~RvR > > ---------------------------(end of broadcast)--------------------------- > TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED] > ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster