test表,字段类型如下:
内容如下:
执行语句:
select * from test as t1 where not exists(select * from (select 姓名,日期 from test where right('0'+时间,6) between '113000' and '133000') as t2 where t1.姓名=t2.姓名 and t1.日期=t2.日期)
查询结果: