Multiple Max Statements
Posted on 2016-09-16
I have the current code in my where clause:
and prh.beg_date = (select max(prh.beg_date)
from prod.prratehist prh
where prh.employee = emp.employee )
Another criteria I need to put in is max(seq_nbr).
Can I put this in the order by clause?
If not, how else could I do this?