å¥ä»¬ï¼å¨è¿ç§æ
åµä¸ç¨decodeå°±æ¯ä¸ªæ»
è¿æ¯ç¨ä¸è½çcase when å§
select deptno,job,avg(nvl(sal,0)) å¹³åå·¥èµ,avg(nvl(comm,0)) å¹³åå¥é,
case when avg(nvl(comm,0))>300 then 'å¥éä¸é'
when avg(nvl(comm,0)) between 100 and 300 then 'å¥éä¸è¬'
when avg(nvl(comm,0))<100 then 'åºæ¬æ²¡æå¥é' end å¥éç¶åµ
from emp group by deptno,job