第9講oracle單行函數(shù)(已改無錯(cuò)字)
2022-07-27 15:45:24 本頁面
【正文】 39。CLERK39。,sal*, 39。MANAGER39。,sal*, sal) revised_salfrom emp。JOB SAL REVISED_SAL CLERK 1840SALESMAN 1600SALESMAN 1250MANAGER 3570SALESMAN 1250MANAGER 3420MANAGER 1800ANALYST 3300PRESIDENT 5000SALESMAN 1500CLERK 1265CLERK ANALYST 3300CLERK 1495例2：按雇員的月薪確定相應(yīng)的稅率。select ename,sal,m, decode(trunc((sal+nvl(m,0))/1000,0), 0, , 1, , 2, , 3, , 4, , ) tax_ratefrom emp。ENAME SAL COMM TAX_RATE SMITH ALLEN WARD JONES MARTIN BLAKE CLARK SCOTT KING TURNER ADAMS JAMES 0FORD MILLER 練習(xí)：依據(jù)例2中確定的稅率計(jì)算雇員月稅金。顯示雇員姓名、工資、薪水、稅率和稅金。select ename,sal,m, (msal1000)* tax_sal from emp e, (select empno,(sal+nvl(m,0)) msal, decode(trunc((sal+nvl(m,0))/1000,0), 0, , 1, , 2, , 3, , 4, , ) tax_rate from emp)twhere =。ENAME SAL COMM TAX_RATE TAX_SAL SMITH 90ALLEN 90WARD 75JONES
黨政相關(guān)相關(guān)推薦
鄂ICP備17016276號(hào)-1