别名

select sal,comm,sal+ifnull(comm,0) as money from emp;

as关键字可以省略

select ename eame,sal,comm,sal+ifnull(comm,0) as money from emp;