Hello,
I am newbie for PL/SQL.
I am trying to create a script/procedure to do the following:
Sample table:
Flag VARCHAR2(1)
JOHN VACHAR2(10)
SUSAN VARCHAR2(12)
DATE_ENTERED DATE;
The Flag will have a value of Y or N
There are duplicate records in the table.
I need to create a PL/SQL procedure that will extract 1 single record which has a value of Y with the "most recent date" entry for JOHN and similarly 1 record for SUSAN.
Thus, there will be two respective records for JOHN and SUSAN with the most recent enry with a flag of Y.
Please help!
shanyaj
I am newbie for PL/SQL.
I am trying to create a script/procedure to do the following:
Sample table:
Flag VARCHAR2(1)
JOHN VACHAR2(10)
SUSAN VARCHAR2(12)
DATE_ENTERED DATE;
The Flag will have a value of Y or N
There are duplicate records in the table.
I need to create a PL/SQL procedure that will extract 1 single record which has a value of Y with the "most recent date" entry for JOHN and similarly 1 record for SUSAN.
Thus, there will be two respective records for JOHN and SUSAN with the most recent enry with a flag of Y.
Please help!
shanyaj