Home » SQL & PL/SQL » SQL & PL/SQL » yearwise revenue - reg
yearwise revenue - reg [message #966] Fri, 15 March 2002 21:47 Go to next message
V.ARANGASWAMY
Messages: 4
Registered: March 2002
Junior Member
Dear all,

I want to take financial yearwise revenue i.e. like (April, 1999 to March,2000), (April, 2000 to March 2001), etc.

The table in question contain the column named as 'YYMM' and entries in this column would be like 199903, 199904, 199905, etc.

The column meant for revenue is also in the same table named as 'EXCISE_DUTY'.

How to do this.

If u post the reply quickly it would be of much use.

With warm regards,

Arangas.
Re: yearwise revenue - reg [message #977 is a reply to message #966] Mon, 18 March 2002 01:03 Go to previous message
pratap kumar tripathy
Messages: 660
Registered: January 2002
Senior Member
see my previous post . it should solve ur problem.
Previous Topic: Unsure about my statements.. Need HELP urgently!! THANX
Next Topic: Oracle Suitable data type
Goto Forum:
  


Current Time: Tue Apr 23 11:43:08 CDT 2024