Try

SELECT * FROM mytable mt1
 WHERE NOT EXISTS (SELECT * FROM mytable mt2 
             WHERE mt2.Empid = mt1.Empid AND mt2.PostDate > mt1.PostDate)

>
>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?
>
>
>