Home » SQL & PL/SQL » SQL & PL/SQL » Need Help on average and sort (SQL
Need Help on average and sort [message #342019] Thu, 21 August 2008 01:40 Go to next message
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 423 times)
Re: Need Help on average and sort [message #342020 is a reply to message #342019] Thu, 21 August 2008 01:45 Go to previous message
Michel Cadot
Messages: 63912
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Post a test case: create table and insert statements along with the result you want with these data.

Post what you already tried and why it does not work.

Previous Topic: Write to file, send to email and pause...
Next Topic: rownum gives no data found!!!!!!!!!!!!111
Goto Forum:

Current Time: Sun Oct 23 19:11:22 CDT 2016

Total time taken to generate the page: 0.06480 seconds