SELECT * FROM dbo.
JOIN dbo. ON dbo..userid=dbo..userid
where 1=1
${if(len(name)==0,"","and dbo..name like '%"+name+"%'")}
${if(len(时间)==0,"","and dbo..CHECKTIME like '%"+时间+"%'")}
${if(len(开始日期)==0,"","and dbo..CHECKTIME between '"+开始日期+"'")}
${if(len(截止日期)==0,"","and '"+截止日期+"'")}
现在使用的考勤,打卡会记录每次打卡的时间。如何写参数,或者其他方法,
只查询当天日期里最早的一条记录呢?