Need help to generate an SQL report from Oracle

[ronm0666]

I am new at SQL and I need a formula. I am trying to get a part cost data report. The problem is that the system holds all the entry dates and part numbers EVERY time the part costs change. Therefore, the entry dates and part #'s are listed many times for each time the costs changes. What I need is the LAST entry date per part and that will give me the latest cost for those parts. NOTE: The last entry dates for the parts are not the same (some are & some aren't). Here are the columns: Entry Date (ENT_DAT), Part Number (PT_NO) and Part Cost (PT_COST). The daytabase name is KDL0016.

Thank You

 

[TimboA]

Try using the Oracle max function on the ENT_DAT field eg :-

select max(ent_dat) ,pt_no, pt_cost
from ent_table
group by pt_no, pt_cost


I think this should do the trick for you.