列出所有员工的年工资,按年薪从低到高排序。(nvl:空转化函数) SQL> select ename,sal*12+nvl(comm,0) anuual_sal from emp order by anuual_sal asc; ENAME ANUUAL_SAL --- --- SMITH 19200 JAMES 22800 ADAMS 26400 CLARK 29424 WARD 30500 MILLER 31236...
百度试题 结果1 题目列出所有员工的年工资,按年薪从低到高排序。相关知识点: 试题来源: 解析 分析: select ename, sal*12 from emp order by sal*12 asc; 反馈 收藏
select*fromemployeeorderbydeptiddesc,salaryascselecteid,ename,salary,deptidfromemployeeorderbydeptiddesc,salaryasc排序没得改，只能改字段