Skip to Main Content
Forums

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!

Compare Sales within two date range

787094Nov 8 2010 — edited Nov 9 2010
Hi All,
I need to compare two date range data in same table. Suppose I have table as follows :

trndate date,
empcode varchar2(50),
custcode varchar2(50),
totalvalue number

Now, I need to compare sales between 01-OCT-2010 to 08-OCT-2010 and 01-NOV-2010 to 08-NOV-2010

Please help..

Thanks
Niloy

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Dec 7 2010
Added on Nov 8 2010
11 comments
3,072 views