Question

oracle数据库emp表中如何查询所有人年薪

使用select ename,(sal+comm)*12 as "nianxin" from emp;那些comm为null的用户不显示，怎么解决？

Answer 1

select ename,(sal+decode(comm,null,0,comm))*12 as "nianxin" from emp

追问

666，刚刚发现用nvl也可以的