Greetings,

I have data in a file with employee, postdate, and accrued vacation. There is other data in the record that is irrelevent to this query.

The data looks like this:

Empid PostDate Hours
AAB01 01/02/05 40
AAB01 02/02/05 40
AAB01 03/02/05 40
AAB01 04/02/05 80
AAB01 05/02/05 80
BBB01 01/06/05 30
BBB01 02/06/05 30
BBB01 03/06/05 40
BBB01 04/06/05 20
BBB01 05/06/05 20

For my query I always need to get the latest postDate for each employee along with the hours.

So the result I'm looking for given this data is:

AAB01 05/02/05 80
BBB01 05/06/05 20

What would be the best way to handle this type of query?


Thanks in advance.