<div>
<div class="content wysiwyg-content">
I have a column &quot;business_date&quot; of date datatype inside my table. Data is uploaded almost daily into that table.<br />
<br />
I want to write a query to find the maximum value populated in this column for every month for the last 5 months.<br />
<br />
How can I do this?
</div>
</div>


I have a column "business_date" of date datatype inside my table. Data is uploaded almost daily into that table.

I want to write a query to find the maximum value populated in this column for every month for the last 5 months.

How can I do this?

Maximum value populated in a date column for each of last 5 months

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.