Skip to Main Content

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!

select query to select month range based on current date.

lm422407shJun 25 2013 — edited Jun 25 2013

It is oracel 10 g data base.

I want to select two months data from the table. But  These two months should based on current date.

For eg.

If I run the select query on July 7 2013 , then query should skip current month which is July 2013 and last month which is June 2013 and It shoud select only May 2013 and April 2013.

Can someone help me how to form this query.

This post has been answered by Chris Hunt on Jun 25 2013
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 23 2013
Added on Jun 25 2013
5 comments
3,116 views