以下查询返回“ ORA-00904错误：SATIS：无效的标识符”。当我删除该行时HAVING satis > 0，它可以工作。我该怎么办？ ; c$ I3 \/ O! W+ R' ]9 `SELECT donem, bolge_adi, sehir_tasra "1=艦, 2=T", : Y1 c0 Y, t; B( [2 Y
COUNT(DISTINCT mekankodu) "M.SAYISI", ) z0 f1 O* d, b SUM(b2b_dagitim + b2b_transfer - b2b_iade) satis7 _: u0 O. Q* {# k) C: |
FROM mps_view2' A& o% w% Y. |
WHERE donem IN ('200612','200712','200812','200912') / y6 \: _+ X' [AND (ob IS NOT NULL OR b2b_ob IS NOT NULL) ( K/ |; ~- ?* `GROUP BY donem, bolge_adi, sehir_tasra, H$ g" s; }8 V6 e7 g! d
HAVING satis > 08 j( n. J$ R+ @4 K5 p
ORDER BY donem, bolge_adi, sehir_tasra: \" D0 t% @* ^4 D0 A5 m2 B6 f
7 f" u& s5 Z" V. p 解决方案:
技术问答
353 人阅读
|
0 人回复
|
2023-09-12
