query

From: Ankur Arora <"Ankur Arora"(at)clear(dot)net(dot)nz>
To: pgsql-novice(at)postgresql(dot)org
Subject: query
Date: 2004-01-17 11:02:42
Message-ID: "NHBBIGMNELLOEJPKCNHHAEACCAAA.AnkurArora"@clear.net.nz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

hello there
i have a problem
i want to know the query for finding out aggregate

eg. i have a column named sum in table xyz

sum
----
2
4
7
5

i want a sql query that will give me another column alongwith this column as
aggregate

sum aggregate
-----
2 2
4 6
7 13
5 18

if u could help me i will be obliged as i really need it on urgent basis

thanx
vibha

Responses

  • Re: query at 2004-01-19 05:20:13 from Bruno Wolff III

Browse pgsql-novice by date

  From Date Subject
Next Message Alan T. Miller 2004-01-18 00:38:05 indexing date and timestamp fields...
Previous Message joseph speigle 2004-01-17 05:37:11 Re: changing start value of sequence after it was created...