Home » SQL & PL/SQL » SQL & PL/SQL » I need a query
I need a query [message #241394] Tue, 29 May 2007 08:02 Go to next message
S.Sudhakar
Messages: 10
Registered: July 2004
Junior Member
Hi,

I have item_code, qty_sold and sold_date columns in a table. Through a query I want to find out number of qty sold for a item in the recent period of 0-90 days, 91-120, 121-150 and so on.

Please give a query as early as possible.

Thanks,
Sudhakar S.
Re: I need a query [message #241407 is a reply to message #241394] Tue, 29 May 2007 08:48 Go to previous messageGo to next message
d.dineshkumar
Messages: 211
Registered: April 2005
Location: Kolkatta
Senior Member
hi
you can do that by using some analytical function.

Bye
Re: I need a query [message #241419 is a reply to message #241394] Tue, 29 May 2007 09:29 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Post your Oracle version and a description of your table as soon as possible.

Regards
Michel
Previous Topic: Query getting 2 extra rows. Could somebody crack it please?
Next Topic: query problem
Goto Forum:
  


Current Time: Sun Dec 04 04:50:59 CST 2016

Total time taken to generate the page: 0.14352 seconds