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
Messages: 10
Registered: July 2004
Junior Member

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.

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
Messages: 211
Registered: April 2005
Location: Kolkatta
Senior Member
you can do that by using some analytical function.

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: 63924
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.

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

Current Time: Wed Oct 26 04:48:32 CDT 2016

Total time taken to generate the page: 0.09425 seconds