##问题代码
select id
from abc
where a = 1
and status = 2
and (offline_time < now() and offline_time > (now()-INTERVAL '3 minute'))
##提示问题
syntax error, expect ), actual LITERAL_CHARS pos 199, line 6, column 97, token LITERAL_CHARS 3 minute
##解决方案
将单引号只引 ‘3’
select id
from abc
where a = 1
and status = 2 and (offline_time < now() and offline_time > (now()-INTERVAL '3' minute))