Oracle Analytical functions - Qn

From: Reji <rejib_at_yahoo.com>
Date: 9 Nov 2002 13:30:37 -0800
Message-ID: <ce0b2a83.0211091330.4b444432_at_posting.google.com>

I have the following data set:

ID                 ID2              BYTES
1000               1000             1000
1000               1200             2000
1000               1300             2000
1200               1400             5000
1200               1000             5000
1250               1400             5000

Assume that ID and ID2 are two locations and BYTES - number of bytes transfered from ID to ID2

I would like to produce couple of results

Shared percentage of data transfered from each ID

Ex with this data set

ID              Shared percentage
1000             25% (5000/20000)*100
1200             50%
1250             25%

I would like to use oracle analytical function if I can...please help me here

RB Received on Sat Nov 09 2002 - 22:30:37 CET

This message: [ Message body ]
Next message: sudheer: "using parameters as it is in pl/sql queries"
Previous message: Pascal Gineste: "Retrieve "alter session" made by other sessions ?"
Next in thread: Jusung Yang: "Re: Oracle Analytical functions - Qn"
Reply: Jusung Yang: "Re: Oracle Analytical functions - Qn"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message