Need Help on average and sort [message #342019] |
Thu, 21 August 2008 01:40  |
suhasbhide
Messages: 9 Registered: February 2008
|
Junior Member |
|
|
I have storage data stored in Oracle database and need to create some reports. Here is the striped down structure of the database.
I am attaching the striped down version of the table and expected result. I have tried the average but does not work.
As can seen in excel, first table is data and 2nd is expected results.
1st column is same value, 2nd column (sd_id) changes. Basically the table shows virtual disks on server with multiple paths. e.g. A01 has 4 paths as shown by 4 different HOST_NAME entries.
I need to pick up unique SD_NAME, corresponding SD_TOTAL and lowest HOST_NAME value.
Thanks....Suhas Bhide
-
Attachment: Book29.pdf
(Size: 13.66KB, Downloaded 1039 times)
|
|
|
|