age ---
From: Phong & Ronni Bounmixay <[EMAIL PROTECTED]>
To: pgsql-general@postgresql.org
Sent: Mon, 28 Nov 2005 13:18:41 -0700
Subject: [GENERAL] sub select as a data column
> I am having trouble coming up with words to describe exactly what I need so
> searching for a solution is
You both are SO right! I sent that off and tried a couple of
things and realized I was close but not close enough. I really
appreciate the kind responses. Sometimes it's so hard to ask a
question without feeling so foolish and then feeling worse when the
answers are sarcastic. Thank you!
Good
Phong & Ronni Bounmixay <[EMAIL PROTECTED]> writes:
> I want to do in postgresql what I do in oracle:
> select year report_year,
> sum(amount),
> sum(select amount from my_table where year <= report_year)
> from my_table
> group by report_year;
That doesn't really work in Oracle
I am having trouble coming up with words to describe exactly what I
need so searching for a solution is getting frustrating! If this
has been answered twelve hundred times - please forgive me!
I want to do in postgresql what I do in oracle:
select year report_year,
sum(amount),
