Steve

may be this works for you:

SELECT employee,MAX(date) as maxdate, wage,... FROM wage GROUP BY employee

Giesbert