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!

Pulling last 18 months worth of data in rolling table

82656d3b-b15e-469a-bb08-a5b477c64d57Jul 28 2016 — edited Jul 28 2016

Hello All,

First time in the forum

I had a quick question, I have a rolling dataset in a table that I'm working off of.  For needs of a report, I have to pull just the last 18 months worth of data.  My field that I want to work off of is a Rpt_Month field and it lists out the month as:

07-01-2016

So my simple query that I am trying to run is

Select *

from table_a

where rpt_month = (last 18 months)    

This will get fed into an SSAS cube to build my report off of.  Any help would be greatly appreciated!!!
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 25 2016
Added on Jul 28 2016
5 comments
1,597 views