SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

percentage increase or decrease in counts

3351Aug 31 2004 — edited Sep 2 2004

Hi All

Here is what i want to acheive.
Say I have a table emp with the date column (hiredate)
I have to take counts for one month say month of August 2004. Then I want to take a count for the previous month July 2004 and then display the perecentage increase or decrease for August over July
How to acheive this.

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 30 2004

Added on Aug 31 2004

6 comments

1,005 views