SELECT ID,ADDRESS 
FROM EMPLOYEE A 
WHERE ID=12345 
AND CURRENT DATE BETWEEN A.EFF_DT AND A.EXP_DT 

SELECT ID,ADDRESS 
FROM EMPLOYEE A 
WHERE ID=12345 
AND CURRENT DATE >= A.EFF_DT AND CURRENT DATE <= A.EXP_DT

在这两个查询中,查询会产生更好的性能.

这里我使用运算符> =和< =而不是BETWEEN. 请建议. 提前致谢.