Re: SQL question

Interesting question.
I think this might work:
select ename, value1, value2, systime
from mytable
where ename, systime in (

        select ename, max(systime)
        from mytable
        group by ename)

If the emp has two entries on the same day it won't work.

But you didn't say how you wanted to handle that case. Paul Dorsey
Dulcian Inc. Received on Fri Jan 12 1996 - 19:15:06 CST