Home » SQL & PL/SQL » SQL & PL/SQL » groupwise top 3 items
groupwise top 3 items [message #7937] Thu, 17 July 2003 06:55
ARANGASWAMY.V.
Messages: 29
Registered: April 2002
Junior Member
companies are paying different rates of taxes for each items manufactured by them.

I wanted to take the sum of the taxes (paid by the companies)company-wise item-wise only top 3 items (for each company).

ex:

company tax item

opel-astra $20 car
opel-astra $222 car
opel-astra $12 van
opel-astra $35 van
opel-astra $21 bus
Honda $11 two wheeler
Honda $65 two wheeler
Honda $47 two wheeler
Honda $31 four wheeler
Honda $91 sports car
Honda $23 sports car
Previous Topic: oracle performance problem
Next Topic: Metadata.
Goto Forum:
  


Current Time: Thu Apr 25 23:15:45 CDT 2024