<div>
If the post above with nvl(complete_date, sysdate) does not answer the question:<br />
<br />
I'm not understanding the inputs/outputs.<br />
<br />
I see what looks like three sets of inputs and no expected results.<br />
<br />
Please post expected results.
</div>


If the post above with nvl(complete_date, sysdate) does not answer the question:

I'm not understanding the inputs/outputs.

I see what looks like three sets of inputs and no expected results.

Please post expected results.

<div>
The results were posted:<br />
<br />
RESULT:<br />
<br />
&nbsp;TASK1 &nbsp; &nbsp;IN_PROGRESS<br />
&nbsp;TASK2 &nbsp; &nbsp;ASSIGN<br />
&nbsp;TASK3 &nbsp; &nbsp;COMPLETE<br />
<br />
<br />
AngelIII's solution &nbsp;works well.
</div>


The results were posted:

RESULT:

 TASK1    IN_PROGRESS
 TASK2    ASSIGN
 TASK3    COMPLETE


AngelIII's solution  works well.

<div>
<div class="content wysiwyg-content">
How would I construct a SQL to get the this result <br />
RESULT:<br />
<br />
&nbsp;TASK1 &nbsp; &nbsp;IN_PROGRESS<br />
&nbsp;TASK2 &nbsp; &nbsp;ASSIGN<br />
&nbsp;TASK3 &nbsp; &nbsp;COMPLETE<br />
<br />
INPUT:<br />
P_ID &nbsp; &nbsp;TITLE &nbsp; &nbsp;COMPLETE_DATE &nbsp; &nbsp;STATUS<br />
1 &nbsp; &nbsp; &nbsp; &nbsp; TASK1 &nbsp; &nbsp;01/01/2011 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; COMPLETED<br />
1 &nbsp; &nbsp; &nbsp; &nbsp; TASK1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; IN_PROGRESS<br />
<br />
P1_ID &nbsp; TITLE &nbsp; &nbsp;COMPLETE_DATE &nbsp; STATUS<br />
1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;TASK2 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;ASSIGN<br />
<br />
<br />
PI_ID &nbsp; TITLE &nbsp; &nbsp;COMPLETE_DATE &nbsp; &nbsp;STATUS<br />
&nbsp;1 &nbsp; &nbsp; &nbsp;TASK3 &nbsp; &nbsp; 01/01/2012 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; CLOSE-OUT<br />
&nbsp;1 &nbsp; &nbsp; &nbsp;TASK3 &nbsp; &nbsp; 07/23/2012 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; COMPLETED
</div>
</div>


How would I construct a SQL to get the this result 
RESULT:

 TASK1    IN_PROGRESS
 TASK2    ASSIGN
 TASK3    COMPLETE

INPUT:
P_ID    TITLE    COMPLETE_DATE    STATUS
1         TASK1    01/01/2011             COMPLETED
1         TASK1                                   IN_PROGRESS

P1_ID   TITLE    COMPLETE_DATE   STATUS
1          TASK2	                       ASSIGN


PI_ID   TITLE    COMPLETE_DATE    STATUS
 1      TASK3     01/01/2012             CLOSE-OUT
 1      TASK3     07/23/2012             COMPLETED

Get max date or null date - ORACLE 11g

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.