Re: SQL to compute sums (similar to SQL*plus break on <column> compute sum of <other_col> on <column>)

On Thu, 29 Nov 2001 20:17:41 GMT, andreyNSPAM_at_bookexchange.net (NetComrade) wrote:
>I know there is some 'new' SQL that can do this, but can't think of a
>way to look for it. Although not sure which version it was introduced
>in 8i or 9i.
>
>Can you point me into the right direction?

Stuff like this is generally categorized as "analytic functions". Not sure which one is appropriate in this case, but you can find 8.1.7 details (under the "examples" and "reference" subheadings) at:

http://tahiti.oracle.com/pls/tahiti/tahiti.drilldown?remark=&word=analytic&book=&preference=&vbook=1

John

--
Got an Oracle database question?
Try the search engine for the database docs at:
http://tahiti.oracle.com/