以下查询返回“ 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 解决方案: