selecting a result based on latest date

[shefea]

Hi,
I could use some help, please.
I have a table with
Emp_name,
Certif_date,
work_loc columns.
I want to select the emp_name,work_loc and the latest (most
recent) certif_date.
some emp_names have multiple certif_dates and I want to latest one.

I am familian with if begin and case statements a bit, but I cannot figure out how to compare the dates.

Please help, thanks in advance.
shefea

 

[swampBoogie]

select emp_name,work_loc,max(certif_date) from t
group by emp_name,work_loc