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. |
복습용 저장
이 항목을 북마크하거나, 어렵게 표시하거나, 복습 세트에 넣을 수 있습니다.
도움이 되었나요? 예 아니요
Most helpful rated by users: