Wilder1626
asked on
Oracle - max date filter issue
Hello all
I have this query bellow that pulls the Max date.
But when i query, i dont get the max date.
Example:
From resources table:
From Query result:
How can i fix that please?
Thanks again for your help
I have this query bellow that pulls the Max date.
But when i query, i dont get the max date.
SELECT DISTINCT A.CARRIER_ID,
MAX (A.EFFECTIVE),
A.TRLR_TYPE_ID,
A.CURRENT_NUM_VEHICLES,
L.NAME
FROM TL_RESOURCE_TRLR A, CARRIER_EQUIP B,LANE L
WHERE A.CARRIER_ID = B.CARRIER_ID(+)
AND A.TRLR_TYPE_ID = B.TRLR_TYPE_ID(+)
AND A.LANE_ID = L.ID
AND B.CARRIER_ID IS NULL -- EXCLUDE ROWS ADDED BECAUSE OF THE OUTER JOIN
GROUP BY a.carrier_id, a.trlr_type_id, current_num_vehicles, L.NAME
ORDER BY A.CARRIER_ID ASC;
Example:
From resources table:
From Query result:
How can i fix that please?
Thanks again for your help
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Hello guys,
Thanks for your help and sorry for the delay. I will work this out a little bit more.
markgeerm you are right.
I will re open another topic when i'm done thinking about all this.
Thanks again
Thanks for your help and sorry for the delay. I will work this out a little bit more.
markgeerm you are right.
I will re open another topic when i'm done thinking about all this.
Thanks again
ASKER
Here you will see the resources extract and also the resources query result.
Thanks again
resources-TABLE.xls
resources-result.xls