Home » SQL & PL/SQL » SQL & PL/SQL » ratio
ratio [message #222110] Thu, 01 March 2007 22:19 Go to next message
Messages: 64
Registered: May 2005
Location: Bangalore
I have the following ratio


i want simplified format as follows

will it be possible to arrive through sql?

Re: ratio [message #222132 is a reply to message #222110] Fri, 02 March 2007 00:09 Go to previous message
Messages: 1845
Registered: November 2006
Senior Member
First you should pick the algorithm.
I would prefer implementation in pl/sql.
However you may try using sql hierarchical queries, maybe it could be achievable too.
Previous Topic: How to load .csv file into the oracle database table.
Next Topic: Two foreign keys for one column
Goto Forum:

Current Time: Wed Jul 26 06:17:01 CDT 2017

Total time taken to generate the page: 0.18269 seconds