SQL 面试题与答案
Question: What does the following query do? SELECT SAL + NVL(COMM,0) FROM EMP;Answer: This displays the total salary of all employees. The null values in the commission column will be replaced by 0 and added to salary. |
保存以便复习
收藏此条目、标记为困难题,或将其加入复习集合。
这有帮助吗? 是 否
用户评价最有帮助的内容: