oracle經(jīng)典查詢答案(編輯修改稿)
2025-02-10 21:18 本頁面
【文章內(nèi)容簡介】 務(wù)期限。 select (select from dept b where =) as deptname ,count(deptno) as deptcount,avg(sal) as deptavgsal from emp a group by deptno。 、部門名稱和工資。 select ,(select from dept b where =), from emp a。 select ,(select count(deptno) from emp b where = group by ) as deptcount from dept a 。 select job,min(sal) from emp group by job(經(jīng)理)的最低薪金。 select deptno,min(sal) from emp where job=39。MANAGER39。 group by deptno。 ,按年薪從低到高排序。 select ename,(sal+nvl(m,0))*12 as salpersal from emp order by salpersal。 （ENAME）第三個(gè)字母是A 的員工姓名。 select ename from emp where ename like 39。__A%39。 和N的員工姓名。 select ename from emp where ename like 39。%A%39。 and ename like 39。%N%39。，列出姓名、工資、傭金，顯示結(jié)果按工資從小到大，傭金從大到小。 select ename,sal+m,m from emp
試題試卷相關(guān)推薦
鄂ICP備17016276號(hào)-1