Query Help regarding finding relationships. [message #254828] |
Sat, 28 July 2007 22:06 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
sibgat
Messages: 45 Registered: November 2006 Location: Chennai
|
Member |
![smssib](/forum/theme/orafaq/images/yahoo.png) ![sibgat](/forum/theme/orafaq/images/skype.png)
|
|
Hi,
A Table contains two columns, column1 and column2 respectively, where these columns represent some relationship which shows a > c , b > d, a >d, c >d. basically column1 > column2
column1 column2
a c
d b
a d
c d
I want the output to be greatest,next greatest, next next greatest like (n,n-1,n-2 etc) like
It would be of great help if you could help in doing this.
Thanks in advance
Regards,
Sibghat
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|