我在下面的日期有硬编码的查询。我的目标是删除已编码的日期；该查询在运行时应提取上个月的数据。8 P) B+ `( R7 x+ m* q* h
select count(distinct switch_id) * Y/ z0 E' G$ C( J from xx_new.xx_cti_call_details@appsread.prd.com : }# f/ E$ w2 H D j) y where dealer_name = 'XXXX' ; b, k2 ^ ^2 w Z9 X+ R and TRUNC(CREATION_DATE) BETWEEN '01-AUG-2012' AND '31-AUG-2012'% L2 `' U6 i8 d5 ~8 y
我应该sysdate-15为此使用函数吗？ 5 x0 S8 G) F& p! N: \& @0 |) U ! B1 B- J( Q0 p 解决方案: ! P' R, N9 w# z. z9 n & i0 A9 J" `( S! H' i- x3 {* F9 y7 r# m l+ S' T# b: u0 A
: B& H o0 ~5 z9 \+ y8 Q 稍微修改Ben的查询，% A8 y# F! c& R& j9 C
select count(distinct switch_id) 7 `7 C d2 `$ X, J8 R2 d
from xx_new.xx_cti_call_details@appsread.prd.com , ^1 \( z# c: q2 l0 u where dealer_name = 'XXXX' + x$ D/ \* w% Y. d3 _: p
and creation_date between add_months(trunc(sysdate,'mm'),-1) and last_day(add_months(trunc(sysdate,'mm'),-1))
技术问答
241 人阅读
|
0 人回复
|
2023-09-14
