以下查询返回“ ORA-00904错误：SATIS：无效的标识符”。当我删除该行时HAVING satis > 0，它可以工作。我该怎么办？ " k- G% [- d l9 t |* b N% qSELECT donem, bolge_adi, sehir_tasra "1=艦, 2=T", ) O5 a, U: ?9 W' r! I. h
COUNT(DISTINCT mekankodu) "M.SAYISI", 9 B6 \5 k% O8 K. x& h SUM(b2b_dagitim + b2b_transfer - b2b_iade) satis i' M6 F4 o( O) w, IFROM mps_view2 % P: H" R; H: fWHERE donem IN ('200612','200712','200812','200912') 7 ?4 K* R- \5 f+ mAND (ob IS NOT NULL OR b2b_ob IS NOT NULL) 0 m, a# n' x+ h7 h8 ^# M" mGROUP BY donem, bolge_adi, sehir_tasra; ]0 z; x- W& [) f
HAVING satis > 0! A. w2 z! F( t9 {6 Q7 U
ORDER BY donem, bolge_adi, sehir_tasra* G3 K2 z/ _% p5 g
技术问答
304 人阅读
|
0 人回复
|
2023-09-12
