last entries

[codesearcher]

I have this DTR record. Employees have daily IN and OUT.

I have this query select dtrdate,empid from DTR group by dtrdate desc,empid order by dtrdate desc limit 1 on mysql db.
the problem with this is I get only for one employee. What I need to achieve is to get the last IN entries for all the employees.


On ms access, I think that is Last().
What is the proper way of the sql statement.

[SamOscarBrown]

Does this work for you?

select dtrdate, empid from DTR group by dtrdate, empid order by dtrdate desc

Just guessing without seeing your table

[Tech99]

Remove / ditch the 'limit 1' and use proper where clause, which selects only IN entries and limit those with max(date) or similar.