17,086
社区成员
发帖
与我相关
我的任务
分享
select H1,H2,INTIME,OUTTIME FROM SSSS WHERE (INTIME >= '201808300100' AND INTIME <= '201808310100') AND H1='123456789'
union all
select H1,H2,INTIME,OUTTIME FROM SSSS WHERE (OUTTIME >= '201808300100' AND OUTTIME <= '201808310100') AND H1='123456789'
你索引都建好的情况下 这样写应该要快个 20s