Where case when条件改写经验总结
1、问题
项目中遇到where case when的写法,如下:
select count(1) from t1
where case when stype1 and cstate in (1,2) then etime
else wtime
END BETWEEN TO_DATE(TO_CHAR(?, YYYY-MM-DD) || 00:00:00, YYYY-MM-DD HH24:MI:SS)
AND TO_DATE(TO…
2026/7/13 6:18:09