I'm in need of a sql query that I'm not sure is possible. Here is an
example of how it's laid out.
employee ID Job class Last Change Date
12345 x 2/1/2004
12345 y 1/15/2004
12345 z 1/1/2004
We know that this person is in job class 'x' because it's the most
recent change. Is there a way to write a query that will exclude the
lines 'y' and 'z' because they are currently incorrect?
I would appreciate any help I could get. Thanks