Home » SQL & PL/SQL » SQL & PL/SQL » Need Help on average and sort (SQL 9.2.0.6.0)
Need Help on average and sort [message #342019] Thu, 21 August 2008 01:40 Go to next message
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)
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: 68733
Registered: March 2007
Location: Saint-Maur, France, https...
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.

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


Current Time: Tue Feb 11 19:13:28 CST 2025