select * from door_inout tem where flag='2--出厂' and datetime_inout=(
select max(datetime_inout) from door_inout where datediff(day,datetime_inout,getdate())=0 and id=tem.id)
我有一个门卫刷卡系统,表door_inout的结构如下:
id ---员工卡号
datetime_inout ----员工进出时间
flag --------------标识位:1--进厂,2--出厂
如何查询出今天最后一次刷卡为:‘2--出厂’的员工记录。
select * from door_inout tem where flag='2--出厂' and datetime_inout=(
select max(datetime_inout) from door_inout where datediff(day,datetime_inout,getdate())=0 group by id having id=tem.id)
select * from door_inout where
datetime_inout = (select max datetime_inout from door_inout where to_char(datetime_inout,'yyyy-mm-dd')=to_char(sysdate,'yyyy-mm-dd') and flag='2')
and flag='2'